home *** CD-ROM | disk | FTP | other *** search
Text File | 1991-01-26 | 277.1 KB | 8,618 lines |
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- ******** CheckMate Plus (tm) ********
- Introductory User's Guide
-
-
- First Edition -- January 1991
-
-
- Copyright 1991 by Custom Technologies
- All Rights Reserved
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- -------------------------------------------------------------------
- Custom Technologies is a member of the
- Association of Shareware Professionals
- -------------------------------------------------------------------
-
-
-
-
-
-
- Warranty and License Agreement
-
- CheckMate Plus (tm) is a trademark of Custom Technologies.
-
-
- Warranty
-
- CheckMate Plus is provided AS IS without any warranty, expressed or
- implied, including but not limited to fitness for a particular
- purpose. CUSTOM TECHNOLOGIES SPECIFICALLY DISCLAIMS ANY AND ALL
- WARRANTIES. IN NO EVENT SHALL CUSTOM TECHNOLOGIES BE LIABLE FOR ANY
- LOSS OF PROFIT OR ANY OTHER COMMERCIAL DAMAGE, INCLUDING BUT NOT
- LIMITED TO SPECIAL, INCIDENTAL, CONSEQUENTIAL OR OTHER DAMAGES
- RESULTING FROM THE USE OF THIS PRODUCT.
-
-
- License
-
- The CheckMate Plus software is the property of Custom Technologies.
- You are granted a license to use this software for a limited time for
- the specific purpose of evaluation before purchase. If you use
- CheckMate Plus on a continuous basis, please register your copy to
- obtain a permanent license.
-
- You are free to make as many copies as you wish and may distribute
- CheckMate Plus freely (in its original form, including disk-based
- documentation). Recipients of copies you make are granted a
- limited license to use CheckMate Plus on a trial and evaluation basis.
- If the recipient wishes to use CheckMate Plus on a continuous basis,
- he should register his copy.
-
- You may not sell or ask any consideration for this product. SIGs and
- BBSs may ask a nominal fee to cover their copying and distribution
- costs. OEMs wishing to bundle CheckMate Plus with other products
- should contact Custom Technologies for details. This User's Guide,
- however, may NOT be reproduced in any form or for any reason without
- the expressed written consent of Custom Technologies.
-
-
-
-
-
-
-
-
-
-
-
-
- Contents
-
-
-
- Chapter 1 Introduction 3
- 1.1 About Shareware . . . . . . . . . . . . . . . . . 3
- 1.2 About this Introductory User's Guide . . . . . . . 4
- 1.3 About CheckMate Plus . . . . . . . . . . . . . . . 5
- 1.3.1 Features . . . . . . . . . . . . . . . . . . 5
- 1.4 System Requirements . . . . . . . . . . . . . . . 7
- 1.5 Installation . . . . . . . . . . . . . . . . . . . 7
- 1.5.1 If you got CheckMate Plus from a Disk
- Vendor . . . . . . . . . . . . . . . . . . . 7
- 1.5.2 If you got CheckMate Plus from a BBS . . . . 8
- 1.6 Upgrading from CheckMate and CheckMate-GL . . . . 8
- 1.7 Running CheckMate Plus . . . . . . . . . . . . . . 8
- 1.8 Getting Started . . . . . . . . . . . . . . . . . 9
-
- Chapter 2 Things You Need to Know 11
- 2.1 Menus . . . . . . . . . . . . . . . . . . . . . 11
- 2.2 The "Bottom Line" . . . . . . . . . . . . . . . 11
- 2.3 The "Top Line" . . . . . . . . . . . . . . . . . 12
- 2.4 Online Help . . . . . . . . . . . . . . . . . . 12
- 2.5 The Calculator . . . . . . . . . . . . . . . . . 12
- 2.6 Special Keys and Shortcuts . . . . . . . . . . . 13
- 2.7 Data Entry . . . . . . . . . . . . . . . . . . . 14
- 2.8 Date Formats . . . . . . . . . . . . . . . . . . 15
- 2.9 Using a Mouse . . . . . . . . . . . . . . . . . 16
- 2.10 The Built-In Editor . . . . . . . . . . . . . . 16
- 2.11 The "Search and Filter" Window . . . . . . . . 17
- 2.11.1 Saving Filter Definitions . . . . . . . . 19
- 2.11.2 Retrieving Filter Definitions . . . . . . 20
- 2.11.3 Deleting Filter Definitions . . . . . . . 20
-
- Chapter 3 Accounts 21
- 3.1 Types of Accounts . . . . . . . . . . . . . . . 21
- 3.1.1 Checking Accounts . . . . . . . . . . . . . 22
- 3.1.2 Other Detail Accounts . . . . . . . . . . . 22
- 3.1.3 Summary Accounts . . . . . . . . . . . . . 23
- 3.2 Entering Accounts . . . . . . . . . . . . . . . 23
- 3.3 Editing Accounts . . . . . . . . . . . . . . . . 25
- 3.4 Selecting Accounts . . . . . . . . . . . . . . . 25
-
-
-
- i
-
-
-
-
-
-
- 3.5 Account Status . . . . . . . . . . . . . . . . . 26
-
- Chapter 4 Transactions 27
- 4.1 Types of Transactions . . . . . . . . . . . . . 27
- 4.1.1 Transactions for Checking Accounts . . . . 27
- 4.1.2 Transactions for Other Accounts . . . . . . 28
- 4.2 Entering Transactions . . . . . . . . . . . . . 28
- 4.2.1 Primary Data . . . . . . . . . . . . . . . 29
- 4.2.2 Splitting the Transaction . . . . . . . . . 30
- 4.2.3 Check Stubs . . . . . . . . . . . . . . . . 31
- 4.2.4 Attaching Notes . . . . . . . . . . . . . . 32
- 4.2.5 Saving the Transaction . . . . . . . . . . 32
- 4.2.6 Picking from the Menu . . . . . . . . . . . 32
- 4.2.7 Utilities . . . . . . . . . . . . . . . . . 32
- 4.3 Editing Transactions . . . . . . . . . . . . . . 34
- 4.3.1 Moving Through the Data . . . . . . . . . . 34
- 4.3.2 Primary Data . . . . . . . . . . . . . . . 35
- 4.3.3 Splitting the Transaction . . . . . . . . . 36
- 4.3.4 Check Stubs . . . . . . . . . . . . . . . . 36
- 4.3.5 Attaching Notes . . . . . . . . . . . . . . 36
- 4.3.6 Saving Your Changes . . . . . . . . . . . . 37
- 4.3.7 Deleting the Transaction . . . . . . . . . 37
- 4.3.8 Picking from the Menu . . . . . . . . . . . 37
- 4.3.9 Utilities . . . . . . . . . . . . . . . . . 37
- 4.4 Automatic Transactions . . . . . . . . . . . . . 38
- 4.4.1 On the Menu . . . . . . . . . . . . . . . . 38
- 4.4.2 Date Activated Transactions . . . . . . . . 41
- 4.4.3 Running Scripts . . . . . . . . . . . . . . 45
- 4.5 The Browse Window . . . . . . . . . . . . . . . 46
- 4.6 Closing Transactions . . . . . . . . . . . . . . 47
-
- Chapter 5 Reports 49
- 5.1 The Transaction Report . . . . . . . . . . . . . 49
- 5.2 General Ledger Reports . . . . . . . . . . . . . 50
- 5.2.1 The Ledger Activity Report . . . . . . . . 50
- 5.2.2 The Ledger Transaction Report . . . . . . . 51
- 5.2.3 The "Chart of Accounts" Report . . . . . . 52
- 5.3 Summary Reports . . . . . . . . . . . . . . . . 52
- 5.3.1 The Balance Sheet . . . . . . . . . . . . . 53
- 5.3.2 The Income Statement . . . . . . . . . . . 54
-
- Chapter 6 Report Printing Options 57
- 6.1 Report Options . . . . . . . . . . . . . . . . . 57
- 6.1.1 Date . . . . . . . . . . . . . . . . . . . 57
- 6.1.2 "Print To" Options . . . . . . . . . . . . 57
- 6.1.3 Title . . . . . . . . . . . . . . . . . . . 59
- 6.1.4 Footer . . . . . . . . . . . . . . . . . . 59
- 6.1.5 The "Utility" Menu . . . . . . . . . . . . 59
-
-
-
- ii
-
-
-
-
-
-
- 6.2 Report Parameters . . . . . . . . . . . . . . . 60
- 6.2.1 Saving Report Parameters . . . . . . . . . 61
- 6.2.2 Retrieving Report Parameters . . . . . . . 62
- 6.2.3 Deleting Report Parameters from Disk . . . 62
- 6.3 "Search and Filter" . . . . . . . . . . . . . . 62
-
- Chapter 7 Designing Custom Reports 63
- 7.1 Report Definition Format . . . . . . . . . . . . 64
- 7.1.1 Account Balances . . . . . . . . . . . . . 65
- 7.1.2 Budget Information . . . . . . . . . . . . 67
- 7.1.3 Calculations . . . . . . . . . . . . . . . 68
- 7.2 Tips on Designing Reports . . . . . . . . . . . 68
-
- Chapter 8 Reconciling Checking Accounts 71
-
- Chapter 9 Printing Checks 75
- 9.1 Printing Your Checks . . . . . . . . . . . . . . 75
- 9.2 Selecting a Check Layout . . . . . . . . . . . . 77
- 9.3 Designing Your Own Check Layout . . . . . . . . 77
- 9.4 The Check Layout Language . . . . . . . . . . . 78
- 9.4.1 Reserved Words and Variables . . . . . . . 78
- 9.4.2 Command Sequence . . . . . . . . . . . . . 79
- 9.4.3 A Simple Example . . . . . . . . . . . . . 80
- 9.4.4 Layout Commands . . . . . . . . . . . . . . 82
- 9.4.5 Built-in Variables . . . . . . . . . . . . 89
- 9.4.6 Expressions . . . . . . . . . . . . . . . . 91
-
- Chapter 10 Graphics 95
- 10.1 System Requirements . . . . . . . . . . . . . . 95
- 10.2 Graphic Reports . . . . . . . . . . . . . . . . 95
- 10.3 "One Account" Graphics Reports . . . . . . . . 96
- 10.3.1 Account Activity Graphics Report . . . . . 96
- 10.3.2 Budget Analysis Graphics Report . . . . . 96
- 10.4 "Ledger" Graphics Reports . . . . . . . . . . . 96
- 10.4.1 Expenses vs Income Graphics Report . . . . 96
- 10.4.2 Expenses by Month Graphics Report . . . . 97
- 10.4.3 Income by Month Graphics Report . . . . . 97
- 10.4.4 Detailed Expense Graphics Report . . . . . 97
- 10.4.5 Detailed Income Graphics Report . . . . . 97
- 10.4.6 Debt to Equity Graphics Report . . . . . . 97
- 10.4.7 Debt to Assets Graphics Report . . . . . . 98
-
- Chapter 11 Rebuilding and Repairing 99
- 11.1 Rebuilding the Database . . . . . . . . . . . . 99
- 11.2 Rebuilding the Index File . . . . . . . . . . . 100
- 11.3 Rebuilding Accounts . . . . . . . . . . . . . . 100
-
-
-
-
-
- iii
-
-
-
-
-
-
- Chapter 12 Financial Calculations 103
- 12.1 Loans . . . . . . . . . . . . . . . . . . . . . 103
- 12.2 Regular Deposits . . . . . . . . . . . . . . . 104
- 12.3 Compounding a Fixed Sum . . . . . . . . . . . . 104
-
- Chapter 13 Setup and Options 105
- 13.1 Fiscal Year Information . . . . . . . . . . . . 105
- 13.2 Protecting Your "Audit Trail" . . . . . . . . . 106
- 13.3 The Screen Saver . . . . . . . . . . . . . . . 107
- 13.4 Colors . . . . . . . . . . . . . . . . . . . . 107
- 13.5 Special Effects . . . . . . . . . . . . . . . . 108
- 13.6 Video Option . . . . . . . . . . . . . . . . . 109
- 13.7 Password Setup . . . . . . . . . . . . . . . . 109
- 13.8 File Paths . . . . . . . . . . . . . . . . . . 110
- 13.9 General Setups . . . . . . . . . . . . . . . . 110
- 13.10 Report Defaults . . . . . . . . . . . . . . . 111
- 13.11 Report Headings . . . . . . . . . . . . . . . 113
-
- Appendix A An Accounting Primer 115
- A.1 What is Accounting? . . . . . . . . . . . . . . 115
- A.1.1 What are ASSETS? . . . . . . . . . . . . . 115
- A.1.2 What are LIABILITIES? . . . . . . . . . . . 116
- A.1.3 What is EQUITY? . . . . . . . . . . . . . . 116
- A.1.4 The Accounting Equation . . . . . . . . . . 116
- A.1.5 What are REVENUE and EXPENSES? . . . . . . 117
- A.2 How does it all work in real life? . . . . . . . 118
- A.2.1 What are ACCOUNTS? . . . . . . . . . . . . 118
- A.2.2 What are DEBITS and CREDITS? . . . . . . . 121
- A.3 Accounting Reports . . . . . . . . . . . . . . . 125
- A.3.1 The Trial Balance . . . . . . . . . . . . . 125
- A.3.2 The Balance Sheet . . . . . . . . . . . . . 127
- A.3.3 The Income Statement . . . . . . . . . . . 130
- A.4 Where does it all end? . . . . . . . . . . . . . 132
- A.5 Final Thoughts . . . . . . . . . . . . . . . . . 133
-
- Appendix B Ordering Checks 135
-
- Appendix C How and Where to get Help 137
- C.1 Technical Support . . . . . . . . . . . . . . . 137
- C.2 Association of Shareware Professionals
- Statement . . . . . . . . . . . . . . . . . . . 138
-
- Index 139
-
-
-
-
-
-
-
-
- iv
-
-
-
-
-
-
-
-
-
-
-
-
- Figures
-
-
- Figure 7.1: A "Test" Custom Balance Sheet . . . . . . . .65
- Figure 7.2: A "Test" Custom Balance Sheet with Account
- Values . . . . . . . . . . . . . . . . . . . .67
- Figure A.1: Chart of Accounts for XYZ Shoes, Inc. . . . 121
- Figure A.2: Sample Transaction . . . . . . . . . . . . . 122
- Figure A.3: Sample Sales Transaction . . . . . . . . . . 123
- Figure A.4: Sample COGS Calculation . . . . . . . . . . 124
- Figure A.5: Trial Balance for XYZ Shoes, Inc . . . . . . 127
- Figure A.6: Balance Sheet for XYZ Shoes, Inc. . . . . . 130
- Figure A.7: Income Statement for XYZ Shoes, Inc. . . . . 131
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- v
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- vi
-
-
-
-
-
-
-
-
-
-
-
-
- Tables
-
-
- Table 2.1: . . . . . . . . . . . . . . . . . . . . . . .14
- Table 2.2: Editing Keys . . . . . . . . . . . . . . . . .15
- Table 2.3: Editor Editing Keys . . . . . . . . . . . . . .17
- Table 2.4: Search and Filter Operators . . . . . . . . . .18
- Table 3.1: Top Level Accounts . . . . . . . . . . . . . .22
- Table 9.1: Check Layout Language Reserved Words . . . . .78
- Table 9.2: Check Layout Language Built-in Variables . . .79
- Table 13.1: Color Toggle Keys . . . . . . . . . . . . . 108
- Table 13.2: Video Options . . . . . . . . . . . . . . . 109
- Table A.1: Assets of XYZ Shoes, Inc as of Mar 1, 1987 . 118
- Table A.2: Liabilities of XYZ Shoes, Inc as of Mar 1,
- 1987 . . . . . . . . . . . . . . . . . . . . 119
- Table A.3: Equity of XYZ Shoes, Inc as of Mar 1, 1987 . 119
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- vii
-
-
-
-
-
-
-
-
-
-
-
- Chapter 1
-
- Introduction
-
-
- 1.1 About Shareware
-
-
- CheckMate Plus, like many other fine "shareware" products, has been
- released by its authors to the public for evaluation. We allow and
- encourage free copying and distribution of the program (in its un-
- altered original form). We are committed to supporting and improving
- CheckMate Plus, as well as developing additional products.
-
- If you find CheckMate Plus useful, you should register your copy. The
- shareware concept is meant to provide a full working copy to the user
- for evaluation, and NOT to give away the author's hard work. If you
- choose not to register, then erase or pass your copy on to someone
- else. You can register by sending $60.00 (plus $5 shipping and
- handling).
-
- When you register, you will be placed on our mailing list and will
- receive a new set of disks and a complete, 208-page illustrated User's
- Guide. The User's Guide is 7"x9", glossy covered, typeset, offset
- press printed, and perfect bound. You will also receive the latest
- version of CheckMate Plus on disk, a special "utilities" disk
- (including a program convert CheckMate and/or CheckMate-GL data to
- CheckMate Plus format), some special offers, and one year of technical
- support (by phone, fax, mail, or CompuServe). We also offer low cost
- upgrades and discounts on future products to registered users.
-
- We accept checks, money orders, CODs, MasterCard, and VISA. Make
- checks payable to Custom Technologies. All payments must be in U.S.
- funds drawn on U.S. or Canadian banks. Colorado residents please add
- 3% sales tax. Send your registration and all other correspondence to:
-
- Custom Technologies
- PO Box 62118
- Colorado Springs, CO 80962-2118
- (719) 260-0402
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 3
-
-
-
-
-
-
- You may also order our products (charge cards or COD) by calling TOLL
- FREE:
-
- 1-800-541-6234 (Orders Only)
-
- If you are outside the United States or Canada and can't call toll
- free, you may reach our order line at:
-
- (719) 260-0486 (Orders Only)
-
- You may also FAX your order to:
-
- (719) 260-0543 (9600 bps, Group 3)
-
- If you have want to make a quantity or dealer purchase, or if you need
- support, call:
-
- (719) 260-0402
-
- Thank you for your support!
-
- *** NOTE: One problem with shareware is that we can't completely
- control distribution of older files. Consequently, our address and/or
- phone numbers are subject to change over time and the ones listed
- above may not be correct.
-
- Although not planned at the moment, we may relocate our business as we
- continue to grow. Our "800" order line should remain in effect
- wherever we set up business. If you attempt to reach one of our
- commercial lines and find them no longer in service, call our 800 line
- for current phone numbers. If you can't call toll-free, then write to
- us (we'll keep our PO box open and arrange forwarding of the mail).
-
-
- 1.2 About this Introductory User's Guide
-
-
- This Introductory User's Guide fully documents all the features of
- CheckMate Plus. Keep in mind, however, that CheckMate Plus is a VERY
- complex program with many, many features and a disk-based manual is
- only of limited use (since we can't include figures and samples).
- None the less, we've tried to make this guide as complete and easy to
- follow as possible.
-
- Registered copies of CheckMate Plus come with a 200+ page, 9"x7",
- perfect bound, professionally typeset manual complete with
- illustrations and index.
-
-
-
-
- CheckMate Plus Introductory User's Guide 4
-
-
-
-
-
-
- 1.3 About CheckMate Plus
-
-
- Thank you for evaluating CheckMate Plus... true "double-entry"
- accounting that's easy enough for home use and powerful enough for
- business!
-
- In 1986, Custom Technologies released CheckMate, an easy to use
- checkbook manager with a delightful user-interface. CheckMate
- redefined what a checkbook database should be.
-
- CheckMate Plus is a natural and powerful descendent of CheckMate.
- We've combined checkbook management, budgeting, accounting, and
- graphics into a highly polished and consistent interface.
-
- To start, CheckMate Plus helps you easily and accurately maintain your
- checking accounts (including simplifying regular monthly transactions
- and printing out your checks).
-
- You can "pre-define" checks that you write often, and even have
- CheckMate Plus "remind" you when they're due. Print the ones you
- want, or write them by hand. (You can freely mix the two methods).
- When your statement arrives, CheckMate Plus will even help you
- reconcile your account!
-
- You can split each check twelve ways. Attach notes. Even "customize"
- the check stub.
-
- Print reports at any time. CheckMate Plus has many standard reports
- (which you can customize or completely redesign!). Preview your
- reports on the screen, write them to disk, or send them to the
- printer. And CheckMate Plus has powerful "search and filter"
- functions to let you zero in on key data.
-
- Since CheckMate Plus is a real double-entry accounting system, you can
- generate balance sheets, income statements, and budgeting reports.
- And don't forget the high resolution color graphics. Whether you're
- tracking a family budget or launching a business, you'll have complete
- financial control effortlessly.
-
- The best feature? EASE OF USE. CheckMate Plus sports pull-down
- menus, pop-up windows, and context-sensitive help.
-
- 1.3.1 Features
-
- o Real "double-entry" accounting that's truly easy enough for
- home and powerful enough for business
-
-
-
-
- CheckMate Plus Introductory User's Guide 5
-
-
-
-
-
-
- o Up to 200 accounts
-
- o Checking accounts support checks, deposits, withdrawals,
- debits, credits, and ATM transactions
-
- o Attach "notes" and "stubs" to each transaction
-
- o Prints checks (computer form, laser, or right out of your
- checkbook!)
-
- o Helps reconcile your checking accounts
-
- o Many powerful and flexible reports (including standard
- accounting reports)
-
- o Powerful "search and filter" functions
-
- o Reports can go to the printer, disk, or the screen
-
- o Financial Calculator (Loans, Deposits, and Compounding) with
- full amortization reports
-
- o High resolution color graphics!
-
- o Multiple ways to view your data ("full screen" & "browse"
- modes)
-
- o Pop-up context-sensitive help
-
- o Pull-down and Pop-up menus throughout
-
- o Pop-up Calculator with rolling tape
-
- o Password Protection
-
- o "Budgeting" capabilities
-
- o Automatic Transactions (pick from a menu or have CheckMate Plus
- "remind" you when they're due!)
-
- o "User-Defined" Reports
-
- o One year of technical support (by mail, phone, fax, or on-line
- with CompuServe!)
-
- o Much, much, more!
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 6
-
-
-
-
-
-
- 1.4 System Requirements
-
-
- CheckMate Plus requires and IBM PC, PS2, or compatible computer
- running MSDOS 3.0 or above. You must have at least 640K bytes of
- memory. If you have less memory, you may be able to run CheckMate
- Plus, but you may find some features are restricted.
-
- We recommend a hard disk for using CheckMate Plus, but it will run on
- a floppy-only system as long as you have at least two drives.
-
- CheckMate Plus supports CGA, EGA, VGA, Hercules, and text-only
- displays. If you want to display graphics, you must have a CGA, EGA,
- VGA, or Hercules adapter and a compatible monitor.
-
- CheckMate Plus will support virtually any printer without any special
- setup. You can pass control codes to the printer in several ways for
- special configurations. CheckMate Plus does not support PostScript
- printers at this time.
-
- CheckMate Plus recognizes the MicroSoft, Logitech, Mouse Systems, or
- any compatible mouse as an input device. You must load your "mouse
- driver" before running CheckMate Plus. See the documentation that
- came with your mouse for more information.
-
-
- 1.5 Installation
-
-
- 1.5.1 If you got CheckMate Plus from a Disk Vendor
-
- If you got CheckMate Plus from a disk vendor, bought the shareware
- disks directly from us, or if you got it from a friend, follow these
- instructions for installing CheckMate Plus.
-
- Place the CheckMate Plus "program" disk in a floppy disk drive. Then
- "log on" to that drive (that is, if you place the disk in drive "A"
- then type "A:" to log on to drive "A").
-
- Now, type
-
- INSTALL <CR>
-
- The <CR> means press "carriage return" (often called "enter" on your
- keyboard). Answer the questions as the INSTALL program directs. It's
- that simple!
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 7
-
-
-
-
-
-
- 1.5.2 If you got CheckMate Plus from a BBS
-
- If you got CheckMate Plus from an electronic BB, follow these
- instructions for installing CheckMate Plus.
-
- Place the following files on a floppy disk (or in a subdirectory on
- your hard drive):
-
- CMPLUS.LZH
- INSTALL.EXE
- LHARC.EXE
-
- Log on to the correct or directory. Now, type
-
- INSTALL <CR>
-
- The <CR> means press "carriage return" (often called "enter" on your
- keyboard). Answer the questions as the INSTALL program directs. It's
- that simple!
-
-
- 1.6 Upgrading from CheckMate and CheckMate-GL
-
-
- We've developed a special program to convert existing CheckMate and/or
- CheckMate-GL data to CheckMate Plus format. The "UPGRADE" program is
- available only to registered users, however.
-
- When you register CheckMate Plus, you'll receive a "utilities" disk
- with the UPGRADE program.
-
- If you registered CheckMate or CheckMate-GL prior to January 1, 1991
- and would like to try CheckMate Plus as shareware before upgrading,
- send us a self-addressed, post-paid diskette mailer ALONG WITH YOUR
- CHECKMATE OR CHECKMATE-GL REGISTRATION NUMBER and we'll send you a
- copy of the utilities diskette.
-
-
- 1.7 Running CheckMate Plus
-
-
- To run CheckMate Plus, go to your CheckMate Plus directory (where you
- told INSTALL to put the program). For instance, if you installed
- CheckMate Plus on drive "C" in a directory called "CMPLUS" you would
- type:
-
- CD \CMPLUS
-
-
-
-
- CheckMate Plus Introductory User's Guide 8
-
-
-
-
-
-
- To get to the CheckMate Plus directory. Once there, type:
-
- CMPLUS <data file path>
-
- to run CheckMate Plus. The <data file path> entry is optional and
- tells CheckMate Plus where to look for (or create) its data files.
- Suppose, for example, that you keep your data in a subdirectory
- (called "DATA") of the "CMPLUS" directory. To run CheckMate Plus,
- type:
-
- CMPLUS C:\CMPLUS\DATA
-
- and CheckMate Plus will open its data files in the "C:\CMPLUS\DATA"
- directory. Likewise, typing:
-
- CMPLUS B:
-
- tells CheckMate Plus to look on drive "B" for data.
-
- You can maintain multiple "sets of books" by placing separate data
- files in different directories or on different disks. If you don't
- specify a data file path, CheckMate Plus will open its files in the
- same directory as the program files.
-
- + TIMESAVER: If you need to maintain many sets of books and don't want
- to remember a bunch of directory names, then create little batch files
- to call CheckMate Plus with the correct directories (see your MSDOS
- manual for more information).
-
- You could also use a "menuing" package such as Custom Technologies'
- "Magic Menus" to automate the selection of files. Contact Custom
- Technologies for more information on "Magic Menus".
-
-
- 1.8 Getting Started
-
-
- When you first run CheckMate Plus, you'll have a "clean" system. That
- means you'll have to define some accounts before you can start making
- entries. You'll do this under the "Accounts" menu. (You can also
- define accounts "on the fly" while entering transactions, so there's
- no need to complete your Chart of Accounts up front).
-
- After you've entered at least one account, you've got to select a
- "control" account before entering any transactions. You'll want to
- pick the account you'll use the most (probably your primary checking
- account).
-
-
-
-
- CheckMate Plus Introductory User's Guide 9
-
-
-
-
-
-
- After selecting a control account, you're ready to use CheckMate Plus!
- You can start entering checks and other transactions immediately.
- Take your time and explore CheckMate Plus while you use it. Remember
- that instant help is available at the touch of the [F1] key!
-
- + IMPORTANT: CheckMate Plus really is a full-fledged "double-entry"
- accounting system. If you're unfamiliar with basic accounting
- principles, read over appendix A ("An Accounting Primer") for an
- introduction. For many of you, that's all the information you'll need
- to effectively use CheckMate Plus. If you have more specialized
- needs, you may want to get a good book, take a class, or talk to a
- CPA.
-
- Also, CheckMate Plus isn't going to "force" anyone to do strict
- accounting! If all you want to do is track your checkbook, that's no
- problem. In fact, you can use CheckMate Plus as just a checkbook
- program now and expand into partial or full accounting at any time!
-
- This User's Guide holds a wealth of valuable tips and timesavers. As
- you become comfortable with CheckMate Plus' primary features, study
- this guide and you'll be able to draw maximum productivity from
- CheckMate Plus!
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 10
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 2
-
- Things You Need to Know
-
-
- 2.1 Menus
-
-
- CheckMate Plus uses the popular "pull-down" menu system as its primary
- user interface. After your start CheckMate Plus, you'll see a row of
- "choices" to choose from. You may select any of the choices in one of
- two ways: first, by moving the high-lighted bar to the item of your
- choice (using the left or right arrow keys or the mouse) and then
- pressing "return" (which we will also refer to as [CR]), or, by
- pressing the starting letter of your choice. Either method will
- instantly produce a secondary menu (with a bar that moves up and down
- instead of left to right). Select individual functions in the same
- manner.
-
- Many other menus in CheckMate Plus will "pop-up" as you need them.
- They work the same as the pull-down menus.
-
- You can exit any menu without action by pressing the [ESC] key.
-
-
- 2.2 The "Bottom Line"
-
-
- As you run CheckMate Plus, the bottom line of the screen summarizes
- many of the functions available to you. It is always present, and
- should speed your use of the program as you become familiar with its
- many capabilities. Most of CheckMate Plus' functions are activated by
- the PC's function keys. The bottom line identifies the operation of
- these keys (and some others).
-
- You should be aware, however, that CheckMate Plus has a lot of
- capability, and there simply is not enough room to list all available
- functions on the bottom line. We've listed those we think are most
- useful. Refer to the online help and this User's Guide for others!
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 11
-
-
-
-
-
-
- 2.3 The "Top Line"
-
-
- The right side of the top line of the screen displays the status of
- your keyboard (CAPS LOCK, NUM LOCK, SCROLL LOCK). It also indicates
- whether you're in insert or overwrite mode (for text entry), and
- whether you've activated the "search and filter" function (FILT).
- [alt-F] toggles the filter flag.
-
- The left side of the top line is reserved for working messages. Don't
- be alarmed if they flash by too fast to read... that simply means your
- computer is fast!
-
-
- 2.4 Online Help
-
-
- CheckMate Plus has built in online, context-sensitive help. Just
- press [F1] at any time while running CheckMate Plus for instant help.
- Some help screens have multiple pages, so use [PgDn], [PgUp], the
- arrow keys, or the mouse to move through the message.
-
- The help screens are contained in the file "CMPLUS.HLP" and this file
- must be present in the program file path (the disk and directory with
- the CheckMate Plus program files) at runtime.
-
-
- 2.5 The Calculator
-
-
- CheckMate Plus includes a pop-up financial calculator. Pressing
- [alt-C] anytime will pop the calculator up. The calculator has a
- rolling tape to help you keep track of your math, and you can even
- direct the output to the printer!
-
- You can scroll through the tape with the up and down arrow keys,
- [PgUp], and [PgDn]. The tape holds the last 100 lines entered.
-
- If you want to use the printer, make sure it is ready before you press
- [P]. The calculator will then echo all output to the printer.
-
- Also, CheckMate Plus automatically asserts the "NUMLOCK" when the
- calculator is invoked so you may use the numeric keypad on the IBM PC
- (or compatibles).
-
- You can "paste" your calculated results into any data field in
- CheckMate Plus by pressing [F2]. (Make sure the cursor is in the
- field you want to paste to BEFORE you activate the calculator). You
-
-
-
- CheckMate Plus Introductory User's Guide 12
-
-
-
-
-
-
- can only paste results after you "total" (i.e. when the "ENTER" block
- in the calculator in not reverse video).
-
- Press [ESC] to exit the calculator and return to CheckMate Plus.
-
-
- 2.6 Special Keys and Shortcuts
-
-
- 2.6.0.1 Shortcuts
-
- In an effort to make CheckMate Plus as "effortless" to use as
- possible, we have incorporated a number of handy "shortcuts" into
- CheckMate Plus' data entry fields. Some of the shortcuts are specific
- to an application (and we will describe them later), others are more
- general.
-
- For instance, any time you're entering dates, you may press the "+"
- key to increment the date by one day. Likewise, the "-" key will
- decrement the date by one day. Pressing "=" forces the date to be the
- default (DOS) date.
-
- Some of the fields requiring numbers (such as the Check Number and
- Account Number fields) will also increment and decrement as you press
- the plus and minus keys.
-
- CheckMate Plus also has "local menus" that give you choices for
- particular fields. The [alt-F10] key is CheckMate Plus' local menu
- key. When you're in such a field, press [alt-F10] to pop the menu up.
- (The [alt-F10] has no effect on "non-local menu" fields). Also, the
- middle button of a three button mouse will pop-up local menus.
-
- 2.6.0.2 Special Keys
-
- Here is a list of keys you should be familiar with while using
- CheckMate Plus:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 13
-
-
-
-
-
-
- Key Function
-
- [alt-F] Toggles "Filter" flag
- [F1] Online help
- [alt-C] Pops up the calculator
- [alt-F10] Local menu key
- [alt-M] Memory status
- [INS] Toggle insert/overwrite
- []alt-A Pops up the Chart of Accounts
-
- Table 2.1:
- Special Keys
-
-
- 2.7 Data Entry
-
-
- CheckMate Plus' data entry fields are among the best in the business.
- As you enter data, you'll find each field "expects" a certain type of
- information and will filter what you type appropriately.
-
- Some of the fields have a limited number of valid choices. You can
- still type whatever you want in the field, and CheckMate Plus will
- attempt to match it to the valid options. If it doesn't match,
- CheckMate Plus will "pop-up" a menu of your choices!
-
- All of the data fields may be edited as you type. The following
- control-key combinations are defined within CheckMate Plus:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 14
-
-
-
-
-
-
- Control Key Alternate Key Function
-
- Control-D right-arrow move one character right
- Control-S left-arrow move one character left
-
- Control-F move one word right
- Control-A move one word left
-
- Control-QD END move to end of text
- Control-QS HOME move to start of field
-
- Control-E up-arrow move up one field
- Control-X down-arrow move down one field
-
- Control-G DEL delete character at cursor
- Control-T delete word right
- Control-QY delete field right
- Control-Y delete entire field
-
- Control-H BACKSPACE delete character left
-
- Control-V INS toggle INSERT/OVERWRITE
-
- Table 2.2: Editing Keys
-
-
-
- 2.8 Date Formats
-
-
- Over the years, we've discovered that different people and different
- lands enter and display "dates" in many different formats.
- Fortunately, CheckMate Plus lets you pick from a wide variety of
- formats to use (under the Setup menu).
-
- CheckMate Plus also allows "free format" date entry in all of its date
- fields. This means you can enter dates in almost any format you want
- and CheckMate Plus will figure out what you mean. For instance,
- 2/12/90, 12 Mar 89, and Sept 10, 1987 are all legal formats to enter
- dates regardless of how you want the date displayed. You need only
- ensure you use some non-alphanumeric delimiter (such as a space or a
- "/") between the month, day, and year. You can even leave all or part
- of the date out and CheckMate Plus will use the defaults (from the DOS
- date).
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 15
-
-
-
-
-
-
- 2.9 Using a Mouse
-
-
- If you have a Microsoft, Logitech, Mouse Systems, or compatible mouse,
- CheckMate Plus will recognize it as an input device. You must load
- your mouse driver BEFORE running CheckMate Plus (see the documentation
- that accompanies your mouse).
-
- In data entry fields, the mouse will "drag" the cursor around as you
- move it. The mouse moves the highlighted bar in menus and in the
- "virtual paper" mode.
-
- The left button acts like the [CR] key and the right button emulates
- the [ ESC] key. If you have a three button mouse, the middle button
- will activate local menus (just like [alt-F10]).
-
-
- 2.10 The Built-In Editor
-
-
- CheckMate Plus has a very simple built-in text editor. You'll use
- this editor when you're working with "stubs" or "notes" in
- transactions, or while defining custom reports or check layouts (for
- printing checks).
-
- The editor is not fancy, but it will get the job done. Many of the
- keys you can use while editing are the same you use in any of the data
- entry fields.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 16
-
-
-
-
-
-
- Control Key Alternate Key Function
-
- Control-D right-arrow move one character right
- Control-S left-arrow move one character left
-
- Control-F move one word right
- Control-A move one word left
-
- Control-QD END move to end of line
- Control-QS HOME move to start of line
- Control-QR jump to top line
- Control-QC jump to bottom line
-
- Control-E up-arrow move up one line
- Control-X down-arrow move down one line
-
- Control-G DEL delete character at cursor
- Control-T delete word right
- Control-QY delete line right
- Control-Y delete entire line
-
- Control-H BACKSPACE delete character left
-
- Control-V INS toggle INSERT/OVERWRITE
-
- Control-KR read text file
- Control-KW write text file
-
- Table 2.3: Editor Editing Keys
-
-
- Although the editor has many basic editing keys, it doesn't have "cut
- and paste" features (yet). You can, however, export the text to a
- file (press control-KW and enter a filename). You can then use your
- favorite text editor to manipulate the data.
-
- Control-KR reads a file into the editor. BE CAREFUL! The file
- "overwrites" anything already there.
-
-
- 2.11 The "Search and Filter" Window
-
-
- At some times while running CheckMate Plus, you'll want to search for
- specific items and disregard others. At those times you'll be able to
- pop-up the "Search and Filter" window.
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 17
-
-
-
-
-
-
- You specify the items you want by setting up "equations". The "search
- and filter" window has six lines, each with five fields:
-
- Variable This first field is where you specify the particular
- variable you're trying to match. You can type the
- variable in yourself, or press [alt-F10] (the local
- menu key) or the middle mouse button to pop-up a menu
- of variables.
-
- OP In the second field, enter the "operator". For
- instance, if you want to exactly match the variable,
- enter a "=" here. This is also a menu field (and
- [alt-F10] will pop-up a menu of choices). Here are
- the operators and what they do:
-
- = Exact Match
- * "Any" Match
- > Greater Than
- < Less Than
- >= Greater Than or Equal To
- <= Less Than or Equal To
- <> Not Equal To
-
- Table 2.4: Search and Filter Operators
-
-
- Most of the operators are self-explanatory, but the
- "*" deserves more detail. You'll use this primarily
- when searching for text. Suppose, for instance, you
- want to find all checks written to "El Paso County".
- You could use the "=" sign and search for "PayTo = El
- Paso County", but you could also use the "*" and
- search for "Payto * County". In other words, when
- you use "*" instead of "=", CheckMate Plus will match
- any check with the word "county" in the payto field.
- When you use "=", you must type in the text to match
- EXACTLY.
-
- Note that "Payto * County" will match any check
- written to "El Paso County", but it will also match
- checks written to "Denver County", "County Line
- Barbecue", or any check with the word "county" in the
- payto field.
-
- Match #1 How this field behaves depends on the "variable" you
- choose (in the "Variable" field). In most cases
- you'll just enter text here. Some variables,
- however, require numbers, "YES/NO", or dates.
-
-
-
- CheckMate Plus Introductory User's Guide 18
-
-
-
-
-
-
- And/Or You can "compound" the search for data with the
- And/Or field. As you may have guessed, you can enter
- either "AND", "OR", or nothing in the field.
-
- Here's how it works. Suppose you want to find all
- transactions between $100 and $200. You'd enter:
-
- Amount >= 100.00 And <= 200.00
-
- See how you've specified a "range" of amounts?
- Similarly, suppose you wanted to find all checks with
- check numbers less than 500 and greater than 1000?
- You'd enter:
-
- Check Number < 500 Or > 1000
-
- You can use these operators and specify "ranges" for
- virtually any variable (including straight text).
-
- If you leave the "And/Or" field blank, CheckMate Plus
- will ignore the second half of the match operation.
-
- OP This second OP field works like the first one above
- (but it's for the second half of the operation).
-
- Match #2 This second "Match" field works like the first one
- above (but it's for the second half of the
- operation).
-
- You can enter up to six operations. In order for a transaction to
- match, it must satisfy all of the lines you enter!
-
- Press [ESC] after you've entered your "filter definition" to return to
- your work.
-
- + IMPORTANT: Even though you've set the filter definition, it has no
- effect until you turn it "on". The [alt-F] key toggles the filter
- state on and off. When you see the word "FILT" on the top line of the
- screen, the filter definition is active. You can toggle it on and off
- at any time!
-
- 2.11.1 Saving Filter Definitions
-
- As you can see, you can get quite detailed in specifying match
- criteria. If you've entered a complicated sequence (and want to save
- it to use again later), press [F10] (while you're in the "Search and
- Filter Window") and CheckMate Plus will store it on disk. You'll have
- to enter a name for the "Filter Definition" so you can pick the one
-
-
-
- CheckMate Plus Introductory User's Guide 19
-
-
-
-
-
-
- you want later. You can have as many as forty definitions saved at
- one time.
-
- 2.11.2 Retrieving Filter Definitions
-
- To retrieve a definition you've saved, enter the "Search and Filter
- Window" and press [F9]. CheckMate Plus will pop-up a menu of
- definitions previously saved. Pick the one you want from the menu.
-
- 2.11.3 Deleting Filter Definitions
-
- To delete a definition (from the disk), pick the one you want to get
- rid of (as described above). Then press [F8]. CheckMate Plus will
- prompt you to confirm before actually deleting the definition.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 20
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 3
-
- Accounts
-
-
- 3.1 Types of Accounts
-
-
- CheckMate Plus focuses around checking accounts since practically
- everyone works through them (both home and business). But to
- accurately track the flow of money, you'll also need to work with some
- other types of accounts. CheckMate Plus defines three major
- categories of accounts: checking accounts, other detail accounts, and
- summary accounts.
-
- Checking accounts refer to your primary bank accounts (of course).
- The "other detail accounts" are your expenses, sources of revenue,
- liabilities (debt), assets other than checking accounts, and your
- equity. (If you have an accounting background, you no doubt recognize
- these categories). Summary accounts are actually "summations" of
- accounts (so you can group accounts into totals). You won't be able
- to directly access summary accounts.
-
- In order to "nicely" divide the different account types, accountants
- have (over the years) devised a more or less "standard" numbering
- convention. CheckMate Plus uses a form of that standard.
-
- 1 - 19999 Assets (Cash, Property, anything you have of value)
- 2 - 29999 Liabilities (Any debts that you owe)
- 3 - 39999 Equity that you hold
- 4 - 49999 Revenue (Pay, Interest, Sales, etc)
- 5 - 59999 Expenses (Utilities, Food, Rent, etc)
-
- All detail accounts (checking accounts and other detail accounts) have
- five digit account numbers (such as 10000 or 50015). Summary accounts
- have one to four digits and "sum together" the detail accounts that
- "fill out" the numbers. For example, the summary account "100" would
- be the sum of accounts 10000 through 10099. The summary account
- "1000" would only sum accounts 10000 through 10009, while the top
- level account ASSETS (account number 1) sums all asset accounts
- (10000-19999).
-
-
-
-
- CheckMate Plus Introductory User's Guide 21
-
-
-
-
-
-
- When you run CheckMate Plus for the first time, it creates six special
- accounts. The first five are the top level summary accounts:
-
- Account Number Name
-
- 1 Assets
- 2 Liabilities
- 3 Equity
- 4 Revenue
- 5 Expenses
-
- Table 3.1: Top Level Accounts
-
-
- The last account CheckMate Plus automatically creates is a detail
- account. CheckMate Plus uses it to make sure your books are always in
- balance. We call this account "Non-Accounted for Funds" and its
- account number is 39999 (it is an EQUITY account). As you make
- entries in CheckMate Plus, any time you do not "balance" a
- transaction, CheckMate Plus automatically assigns the funds to this
- account. Remember, however, that you can always change the
- transactions later!
-
- CheckMate Plus won't let you modify or delete any of these six special
- accounts.
-
- 3.1.1 Checking Accounts
-
- Checking accounts are assets (since they represent money you have).
- They are also detail accounts (which means you can directly transfer
- money to and from them). Therefore, they can have account numbers
- between 10000 and 19999.
-
- CheckMate Plus treats checking accounts in a special way since you'll
- be doing much of your day to day business directly with them.
-
- CheckMate Plus builds in the capability to print checks (including
- addressing them for window envelopes), reconcile (with you bank
- statement), and track other types of transactions (such as deposits,
- services charges, and ATM transactions).
-
- 3.1.2 Other Detail Accounts
-
- You'll also be able to setup accounts to track your other assets,
- liabilities, equity, revenue, and expenses. These accounts are also
- "detail" accounts and will have five digit account numbers (as
- described above).
-
-
-
-
- CheckMate Plus Introductory User's Guide 22
-
-
-
-
-
-
- These accounts are more general, however, and you won't have (or need)
- as many options as you have with with checking accounts.
-
- 3.1.3 Summary Accounts
-
- You'll find "summary" accounts useful for assembling accounts together
- in logical groups. You may, for example, want to list accounts 10000
- (Checking Account), 10001 (Savings Account), and 10008 (Petty Cash)
- under summary account 1000 (Cash Assets).
-
- 1000 Cash Assets
- 10000 Checking Account
- 10001 Savings Account
- 10008 Petty Cash
-
- You can direct CheckMate Plus to report the summaries (with customized
- reports) for a more general analysis of your financial condition.
-
-
- 3.2 Entering Accounts
-
-
- This section of the User's Guide describes how to set up the different
- accounts available in CheckMate Plus.
-
- You define accounts by selecting "Enter New Accounts" from the
- "Accounts" menu. You'll see a secondary menu asking whether you want
- to enter a checking account or an "other" account.
-
- If you select "other", you'll see a third menu from which you can
- select "summary" or other "detail" accounts.
-
- There are some subtle differences between the different types of
- accounts.
-
- All of the fields (in the "Enter Accounts Window") are explained
- below:
-
- Account Name The name for the account (such as "United Bank",
- "Mortgage", or "Utilities Expense". This name will
- appear on all account menus, account fields, and
- reports.
-
- Opening Balance Enter the "balance" of the account on the date you
- want to start tracking it. This may or may not be
- its current balance. It is a good idea to start an
- accounting system on January 1st, so you may want to
-
-
-
-
- CheckMate Plus Introductory User's Guide 23
-
-
-
-
-
-
- "back enter" the data back to the first of the year
- (or whenever your accounting year begins).
-
- After you enter the opening balance, you must tell
- CheckMate Plus on which date the balance applied.
- Remember you may enter the date in any format you
- choose.
-
- Next Check Number
- This field applies to checking accounts only. Enter
- the next check number you'll enter in CheckMate Plus.
-
- Address on Checks
- This field applies to checking accounts only. Enter
- "YES" if you want addresses to appear in the check
- entry form (and on the checks you print).
-
- Account Number CheckMate Plus fills this number in for you (but you
- may change it if you wish). This is the general
- ledger account number for the account you're
- entering. Remember that detail accounts must always
- have five digits.
-
- You may press the plus or minus keys in this field to
- increment or decrement the number. You may not have
- two accounts with the same number.
-
- Check Layout This field applies to checking accounts only. This
- is a "menu field", so you may either type in a
- defined check layout or press [alt-F10] to pop the
- menu up. CheckMate Plus comes with three predefined
- layouts, but you may also enter your own (discussed
- later in this User's Guide).
-
- Contra Account This field applies to all account types except
- checking. Contra accounts are special in accounting.
- If you don't know what contra accounts are, then
- leave this field "NO" (the default). If you do know,
- the field is self explanatory.
-
- Budget Information
- Press [F3] while entering the account to pop-up the
- "Budget Setup Window". Here you can enter budgeting
- data that CheckMate Plus uses in preparing reports.
- [ESC] returns you to the Account Entry Window.
-
- The "quarters" in the budget window are based on the
- start of your fiscal year (see "Fiscal Year Setup"
-
-
-
- CheckMate Plus Introductory User's Guide 24
-
-
-
-
-
-
- under the "Setup" menu). You can, for instance,
- choose to start your accounting year on October 1st
- (rather than January 1st). In this case, The 1st
- Quarter would include October, November, and December
- (instead of January, February, and March).
-
- After you set up the account, press [F10] to save the information and
- add the account to your Chart of Accounts. The window will clear and
- you can enter more accounts (or press [ESC] to return to the Accounts
- Menu).
-
-
- 3.3 Editing Accounts
-
-
- You can modify (or delete) accounts after you've entered them, but
- there are some restrictions. Select "Edit Accounts" from the
- "Accounts" menu. A secondary menu will appear which lists all
- existing accounts. Pick the account you want to edit from the list.
-
- You can change any of the fields in the "Edit Accounts Window" (the
- same fields you saw while entering the account). Press [F10] to save
- your changes, or press [F9] to delete the account.
-
- CheckMate Plus records account numbers in the transactions. You can
- change an account's number, but CheckMate Plus has to search
- completely through the data file and update each applicable
- transaction. This process can be time consuming (if you have a lot of
- transactions), but it is absolutely necessary.
-
- If you delete an account, CheckMate Plus will search the database and
- remove all references to the account. This could very likely leave a
- number of transactions out of balance! In this case, CheckMate Plus
- automatically assigns the debits and credits to the "Non-Accounted for
- Funds" account.
-
- Press [ESC] to return to the "Accounts" menu.
-
-
- 3.4 Selecting Accounts
-
-
- CheckMate Plus is transaction oriented, and you'll spend most of your
- time entering transactions.
-
- You can select which account CheckMate Plus will treat as the control
- account by activating "Select Control Account" under the "Accounts"
- menu. Pick the account you want to treat as the default for
-
-
-
- CheckMate Plus Introductory User's Guide 25
-
-
-
-
-
-
- transaction entry/edit, reports, printing checks, etc. The control
- account's name and number appear in the lower right hand corner of the
- screen.
-
- CheckMate Plus remembers your control account and will automatically
- select it the next time you run the program. We anticipate you'll
- spend most of the time with your primary checking account as the
- default.
-
- + NOTE: Only "detail" accounts will appear on the select menu since
- you can't post transactions directly to summary accounts!
-
- You'll automatically return to the "Accounts" menu when you select
- your control account. You can also press [ESC] to exit the "Select
- Control Account Menu" without changing the control account.
-
-
- 3.5 Account Status
-
-
- When you select "Account Status" from the "Accounts" menu, CheckMate
- Plus will pop-up your Chart of Accounts. Pick one from the menu and
- CheckMate Plus will display pertinent information about that account.
-
- The opening balance is the same as the one entered while defining or
- editing the account. The current balance is "as of" the date of the
- last transaction entered for that account.
-
- If the account is a "summary" account, the numbers CheckMate Plus
- displays are "summations" of the accounts underneath it. CheckMate
- Plus also shows the range of accounts beneath each summary account.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 26
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 4
-
- Transactions
-
-
- 4.1 Types of Transactions
-
-
- 4.1.1 Transactions for Checking Accounts
-
- Checking accounts are special in CheckMate Plus. Here is a list of
- transactions you can enter in checking accounts:
-
- Checks Checks will most likely be the most common
- transaction you'll enter. As you'll see below,
- CheckMate Plus includes a multitude of data fields to
- completely describe your checks. Each check is a
- credit (in accounting terms) to your checking account
- (which is an ASSET account).
-
- Withdrawals Withdrawals (other than checks or ATM withdrawals)
- will be rare in checking accounts, but we have
- included them for completeness. Withdrawals are
- credits to checking accounts.
-
- Deposits Deposits are money you put in the checking account.
- (CheckMate Plus has other transaction types you can
- use for bank credits, such as interest earned). Each
- deposit is a debit to your account.
-
- Bank Debit A "bank debit" is money the bank takes from your
- account (a service charge, for instance). If you
- have any accounting background, you'll realize that a
- bank debit is actually a credit to your checking
- account (which is an ASSET account). We call it a
- "bank debit" because that is usually what the bank
- calls it on your statement.
-
- Bank Credit A "bank credit" (which is actually a debit to your
- checking account) is money the bank puts into your
- account (such as interest earned).
-
-
-
-
- CheckMate Plus Introductory User's Guide 27
-
-
-
-
-
-
- ATM Deposit An "ATM deposit" is simply a deposit you make at an
- automatic teller machine (ATM). There is nothing
- special about this type of deposit, we just added the
- "ATM" to the name since ATMs have become so common.
- An ATM deposit is a debit to your checking account.
-
- ATM Withdrawal Like the ATM deposit described above, an "ATM
- withdrawal" is just a withdrawal made at an automatic
- teller machine. An ATM withdrawal is a credit to
- your checking account.
-
- 4.1.2 Transactions for Other Accounts
-
- You can directly post transactions to other detail accounts, but you
- have (and need) only two options (either DEBIT or CREDIT).
-
- Debits A debit increases an ASSET or EXPENSE account and
- decreases LIABILITY, EQUITY, or REVENUE accounts.
- (This is standard accounting practice). CheckMate
- Plus helps you remember when to use debits (vs
- credits) with helpful menu descriptions as you make
- entries.
-
- Credits As you might expect, credits increase LIABILITY,
- EQUITY, and REVENUE accounts and decrease ASSET and
- EXPENSE accounts. Once again, CheckMate Plus helps
- you keep debits and credits straight with helpful
- menus.
-
- + NOTE: There is an exception the the above rules. Although ASSETS
- are ordinarily debit accounts (and debits INCREASE them), you can have
- a CONTRA ASSET account, which, while still an ASSET, is a CREDIT
- account. You may have contra accounts in any of the account
- categories except checking. Contra accounts are a more advanced
- accounting concept, and most of you will probably not need them. We
- have included the capability for those that do.
-
-
- 4.2 Entering Transactions
-
-
- The first menu on the menu bar is the "Transactions" menu (since
- you'll most likely spend much of your time in CheckMate Plus entering
- transactions). From the "Transactions" menu, select "Enter
- Transactions" to begin transaction entry.
-
- A menu with transaction choices will appear. Checking accounts have
- seven choices (check, withdrawal, deposit, bank debit, bank credit,
-
-
-
- CheckMate Plus Introductory User's Guide 28
-
-
-
-
-
-
- ATM deposit, and ATM withdrawal). All other accounts will have two
- choices (debit or credit).
-
- We'll concentrate on entering checks since they are the most complete.
- The other transaction types are similar, but have fewer data fields.
-
- 4.2.1 Primary Data
-
- The first thing you'll see when you select "Check" from the
- "transaction type" menu is the primary data entry screen.
-
- Check Number CheckMate Plus automatically assigns each check with
- the "next check number". You can override CheckMate
- Plus' choice by pressing the up-arrow key (to move up
- to the check number). Pressing the plus and minus
- keys will increment and decrement the check number
- respectively.
-
- Date The date of the transaction. The default is the
- system (DOS) date. Remember that you can press the
- plus and minus keys to increment or decrement the
- date (or you can enter it free format).
-
- Amount The next field is the "amount" field (which, of
- course, is the amount of the check). After you enter
- the amount, the "spelled out amount" will appear and
- the current account balance will update.
-
- TO The "TO" field is who you're writing the check for
- (the Payee).
-
- Address If you told CheckMate Plus that you wanted to print
- addresses on the checks (while you were defining the
- account), you'll have three lines to enter the
- Payee's address under the Payee's name.
-
- For This is the "memo" or "for" line on the check. You
- can enter a short note here.
-
- Vendor Acct # Many vendors want you to write your account number on
- the checks you send them so they can properly credit
- your account. That's what this field is for.
-
- Comments You have 67 characters to enter miscellaneous
- comments about the check in the "comments" field.
-
- Tax Ded This is a YES/NO flag you can use to designate checks
- as tax deductible. Marking checks in this way makes
-
-
-
- CheckMate Plus Introductory User's Guide 29
-
-
-
-
-
-
- it easy to generate a report of tax deductions at
- year's end.
-
- Marked Like the "Tax Ded" flag, you can "mark" a check with
- this YES/NO flag. This is a general purpose field,
- that is, you can use it for whatever you want.
-
- Printed If you're using CheckMate Plus to print checks,
- CheckMate Plus will mark this field for you when you
- print the check. If you mix writing checks by hand
- and printing them, be sure and mark this field for
- the checks you write out (otherwise CheckMate Plus
- will want to print them). If you're not printing any
- checks, you don't need to bother with this field.
-
- Cleared CheckMate Plus marks this field during the
- reconciliation process. Be careful if you mark this
- field yourself, since the "Date Cleared" should match
- the statement date on which the check cleared.
-
- Date Cleared If the transaction has cleared, this field holds the
- statement date (from the bank statement that the
- check appeared on). CheckMate Plus maintains this
- date so it can completely re-create a statement at
- any time. You should never have to enter this date
- manually as CheckMate Plus enters it during the
- reconciliation process.
-
- 4.2.2 Splitting the Transaction
-
- The transaction itself is only half of the story. CheckMate Plus lets
- you "split" the transaction twelve ways to account for the flow of
- money. Press [F3] while in the "primary data" screen and the "split
- transaction" window will appear.
-
- You'll notice that CheckMate Plus fills in the first line of the
- transaction for you (in fact, you can't edit the first line in the
- "split" window!). CheckMate Plus knows whether to enter a debit or a
- credit and positions the cursor on the next line in the "account
- number" field.
-
- Acct# Enter an account's number here. If you can't
- remember the number of the account you want, press
- the local menu key ([alt-F10]) or press the middle
- button on the mouse to pop-up a pick list. You can
- also use the plus and minus keys to scroll through
- the numbers and search for the right account. The
-
-
-
-
- CheckMate Plus Introductory User's Guide 30
-
-
-
-
-
-
- account's name will automatically appear to the right
- of the number.
-
- Description The "description" field is for you to enter notes to
- yourself (so that the ledger transaction and activity
- reports will make sense to you later). CheckMate
- Plus fills the first description in for you (a check
- number or the "Memo" from other types of
- transactions).
-
- + TIMESAVER: Many times the "description" that you
- want to enter will be the the payee's name (that you
- entered on the check). Press [F3] while in any
- "description" field and CheckMate Plus will "paste"
- the payee's name directly in.
-
- Debit/Credit Enter an appropriate debit or credit in the next two
- fields. You can have either a debit or credit (but
- not both on the same line).
-
- CheckMate Plus totals the transactions as you enter the amounts. When
- the transaction is in "balance" (i.e. when debits=credits"), the
- "Unaccounted For" field will be zero.
-
- + TIMESAVER: At ANY time while you're "splitting" the transaction, you
- can "force" the transaction to "balance" by pressing [ PgDn]. When
- you do this, CheckMate Plus will adjust the debit (or credit) on the
- line the cursor is on to make the transaction balance. You'll find
- this key most useful while entering the "last" line of a transaction.
-
- You can return to the primary data entry screen by pressing [ESC].
-
- 4.2.3 Check Stubs
-
- While entering checks, you can press [F4] to pop-up the "Stub" window.
- This is a text "pad", and you can use CheckMate Plus' built in editor
- to type in text that you can print on check stubs later. (See "Things
- That You Should Know", chapter 2 for information on using the editor).
-
- The "stub" pad has 20 lines and 130 columns.
-
- + NOTE: The "stub" is available for all transactions, not just for
- checks. You can't print them for other transaction types, but you can
- use them for additional notes.
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 31
-
-
-
-
-
-
- 4.2.4 Attaching Notes
-
- If you need space for additional comments or notes, press [alt-F4] to
- pop-up the "Notes" window. Like the check stub, this window is a text
- "pad" and you can use CheckMate Plus' built in editor to enter your
- notes.
-
- The "notes" pad has 10 lines and 70 columns.
-
- 4.2.5 Saving the Transaction
-
- Once you've entered the transaction, press [F10] to save it and update
- all the proper account balances. You may press [ESC] to abort saving.
- (CheckMate Plus will prompt you to confirm as this will cause you to
- lose the data you've entered).
-
- 4.2.6 Picking from the Menu
-
- You've probably noticed that many of the checks you write from month
- to month "repeat". For instance, you probably write either a mortgage
- payment or a rent check each month, as well as utilities, telephone,
- newspaper, etc.
-
- CheckMate Plus lets you define checks (and other transactions) and add
- them to a menu. While you're entering checks you can pop this menu up
- with [alt-F2] and "pick" the transaction you want. This is a
- tremendous timesaver!
-
- You can define as much or as little of the transaction as you like,
- and fill in the rest as you actually enter the check. If the amount
- of the check changes each time you write it (such as your utility
- bill), you can even have CheckMate Plus "jump" to the amount field
- after you pick the transaction from the menu!
-
- The menu may have more entries than can show on the screen at one
- time. Use the arrow keys, [PgUp], [PgDn], or the mouse to scroll
- through the choices.
-
- 4.2.7 Utilities
-
- While you're entering transactions, you can press [F2] at any time to
- pop-up the "Utilities" menu. The options available on the menu will
- depend upon the type of transaction you're entering. Here are the
- choices you may see:
-
- Add Account You may find you want to add accounts while
- "splitting" the transaction. From the "Utilities"
- menu, select "Add Account" and you'll be able to add
-
-
-
- CheckMate Plus Introductory User's Guide 32
-
-
-
-
-
-
- as many accounts as you wish. [ESC] returns you to
- the transaction you're entering.
-
- Edit Transactions
- If you want to "edit" old transactions while you're
- entering a new one, select this option from the
- "Utilities" menu.
-
- Memorize Select "Memorize" from the "Utilities" menu if you
- want to add this transaction to the pop-up menu (so
- you can repeat it later) or if you want to add it to
- the menu or date activated list.
-
- Stub Layout This option applies only to checks, and will
- determine how to print the stub while printing the
- check. When you select this option, another menu
- appears.
-
- Automatic Select
-
- This is the default stub layout. In the automatic
- mode, CheckMate Plus determines whether to print the
- "Accounts Payable" stub (which is a list of accounts
- that you've split the check across) or the custom
- stub (which you enter by pressing [F4]). CheckMate
- Plus looks at the custom stub first. If the first
- line of the stub is blank, it prints the automatic
- stub. Otherwise it will print the custom stub.
-
- No Stub
-
- If you choose "No Stub", CheckMate Plus will not
- print a stub when you print the check (even if the
- check layout calls for one). If necessary, CheckMate
- Plus will print blank lines on the stub (to keep the
- check alignment correct).
-
- Custom Stub
-
- This option forces CheckMate Plus to print the custom
- stub (which you enter when you press [F4] ) even if
- it is empty (in which case CheckMate Plus will print
- blank lines).
-
- Accounts Payable
-
- If you choose this option, CheckMate Plus will always
- print the "Accounts Payable" stub even if the custom
-
-
-
- CheckMate Plus Introductory User's Guide 33
-
-
-
-
-
-
- stub is filled in. The accounts payable stub looks a
- lot like the "split transaction" screen (that is, it
- is a list of the accounts that you're "splitting" the
- check across).
-
- Print the Check You can print the check you're entering as you enter
- it. Just select "Print Check" from the "Utilities"
- menu. Be sure that your check is in the printer and
- ready before you select "Print Check", however, since
- CheckMate Plus will print the check immediately.
-
-
- Rebuild Account This option will only appear on the menu if the
- control account needs to be "rebuilt" to update the
- running balances.
-
-
- 4.3 Editing Transactions
-
-
- Editing transactions is much like entering transactions, but there are
- some substantial differences. This section documents those
- differences.
-
- 4.3.1 Moving Through the Data
-
- When you select "Edit Transactions" from the "Transactions" menu,
- you'll enter the "Edit Transactions Window". The transaction you see
- will depend on two things:
-
- o The current control account
-
- o Whether or not the "Filter Flag" is set
-
- CheckMate Plus only displays transactions for the control account,
- and starts with the last transaction entered. If the "filter flag" is
- set, then the transactions displayed must also match the "search and
- filter" pattern you've set up (provided that the filter flag is
- active). [alt-F] toggles the filter flag. While the filter is
- active, the word "FILT" appears on the "top line" of the screen.
-
- While you're editing, you can use the following keys to move through
- the data file:
-
- [F7] This key moves backwards one transaction. If the
- filter flag is set, then CheckMate Plus keeps moving
- backward until a match is found.
-
-
-
-
- CheckMate Plus Introductory User's Guide 34
-
-
-
-
-
-
- + SPECIAL NOTE: CheckMate Plus has a special feature
- we call "field integrity". This means that you'll
- stay on the same field as you move through the
- database. For instance, if you're on the "check
- number" field and press [F7], CheckMate Plus will
- skip over any transactions that don't have a check
- number (such as deposits or withdrawals).
-
- [F8] This key moves forward one transaction. The action
- is the same as the [F7] key discussed above.
-
- [F5] This key "jumps" to the first transaction of the
- control account. If the filter flag is set, it
- searches for the first "matching" transaction. Field
- integrity is not preserved when you use this key.
-
- [F6] This key "jumps" to the last transaction of the
- control account. If the filter flag is set, it
- searches for the last "matching" transaction. Field
- integrity is not preserved when you use this key.
-
- [alt-J] This is a special search key. When you press [alt-J]
- you'll see a window appear where you may enter a
- "date to jump to". Enter a date and press [CR].
- CheckMate Plus will jump to that date (or as close as
- it can get). The cursor jumps to the date field
- (field integrity is not preservered), and the
- transaction does not have to match the "search and
- filter" pattern!
-
- CheckMate Plus checks to see if the current transaction has been
- modified before it will move forward or backward through the file. If
- you've made any changes, CheckMate Plus prompts you to save your
- changes before proceeding.
-
- 4.3.2 Primary Data
-
- There is very little difference between editing a transaction and
- entering a transaction (discussed above). Those changes are
- documented here:
-
- Balance While entering transactions, the balance CheckMate
- Plus shows is the account's current balance. While
- editing, CheckMate Plus shows the account's running
- balance (that is, the balance of the account when the
- transaction was originally entered).
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 35
-
-
-
-
-
-
- It's not an easy thing to keep this running balance
- correct. If you change the amount or date of a
- transaction (or any amounts or accounts in the
- transactions "split" window), you may disturb the
- accuracy of the running balance. When this happens,
- CheckMate Plus will make the balance "blink" while
- you're editing. As you exit the editing function,
- CheckMate Plus will ask if you want to "rebuild" the
- account (and fix the "blinking"). If you choose not
- to rebuild it, CheckMate Plus will continually ask
- over and over (at strategic times in the program).
-
- Remember, you may also change other accounts (in the
- split window). If CheckMate Plus determines that one
- of these is out of balance, it will warn you when you
- next "select" that account as the control account
- (and ask you if you want to rebuild it). Rebuilding
- any account fixes all of them.
-
- 4.3.3 Splitting the Transaction
-
- Press [F3] to "split" the transaction.
-
- The biggest difference between "editing" and "entering" in the split
- window is that you'll be restricted somewhat while "editing". As when
- entering, you can't edit the first line of the transaction (you can do
- this in the "primary data" window). Also, you won't be able to change
- the Account Number of the account that "owns" the transaction. (The
- account that "owns" a transaction is the account that was the control
- account when you entered the transaction).
-
- 4.3.4 Check Stubs
-
- Press [F4] to edit the "stub".
-
- Remember that each transaction has only one stub (regardless of how
- many accounts you've split the transaction across). So if you edit
- the stub (and the control account doesn't "own" the transaction),
- you'll see the stub that you originally entered. Any changes you make
- will appear in the other accounts as well.
-
- 4.3.5 Attaching Notes
-
- Press [alt-F4] to edit the "notes".
-
- Like the "stub" (discussed above), each transaction has only one note
- pad. Any changes you make to the note pad will appear for all the
- accounts in the transaction.
-
-
-
- CheckMate Plus Introductory User's Guide 36
-
-
-
-
-
-
- 4.3.6 Saving Your Changes
-
- After you've made your changes, press [F10] to save them (or [ESC] to
- abort). If you try to abort changes (with [ESC] or by "moving" to
- another transaction), CheckMate Plus will ask you to confirm your
- intentions before you lose your edits.
-
- 4.3.7 Deleting the Transaction
-
- You can delete a transaction by pressing [F9]. CheckMate Plus will
- prompt you to confirm before actually deleting the transaction.
-
- You can delete a transaction even if the current control account
- doesn't "own" the transaction.
-
- The transaction will "disappear" from ALL of the accounts in the
- transaction, and all of the accounts will need to be rebuilt. When
- you press [ESC] to exit the edit mode, CheckMate Plus will ask you if
- you want to "rebuild". CheckMate Plus rebuilds all accounts at once,
- so you won't have to rebuild each account individually. We don't do
- it automatically since you may be doing a lot of editing and each
- rebuild can take several minutes (if you have a very large data file).
-
- YOU CAN'T RECOVER A TRANSACTION AFTER DELETING IT!
-
- 4.3.8 Picking from the Menu
-
- You can "pick from the menu" by pressing [alt-F2] while editing any
- transaction. Bear in mind, however, that picking a menu transaction
- will completely replace the current transaction, including the "split"
- accounts!
-
- Remember that you can press [ESC] to abort your edits (as long as you
- haven't pressed [F10]) if you change your mind about the menu choice.
-
- 4.3.9 Utilities
-
- While you're editing transactions, you can press [F2] to pop-up the
- "Utilities" menu. The options available on the menu depend upon the
- type of transaction you're editing, and whether or not you need to
- "rebuild" the control account.
-
- Add Account You can add accounts while editing by selecting this
- option from the "Utilities" menu.
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 37
-
-
-
-
-
-
- "Search and Filter"
- Select this option to define the "search and filter"
- pattern you want to match (as you move through the
- database).
-
- Memorize You can add transactions to the menu or "date
- activated" list by "memorizing" the transaction.
- Select this option from the "Utilities" menu and
- follow the menus.
-
- Stub Layout (Checks only). See "Entering Transactions" for a
- complete description of the "stub layouts" available
- to you.
-
- Print the Check (Checks only). Pick this option to immediately print
- the check. May sure that your check is in the
- printer and ready before you select this option!
-
- Rebuild Account This option will only appear on the menu if the
- control account needs to be "rebuilt" to update the
- running balances.
-
-
- 4.4 Automatic Transactions
-
-
- This section discusses how to enter and edit "automatic" transactions
- (transactions that appear on the menu or date activated transactions).
-
- 4.4.1 On the Menu
-
- Automatic transactions that are "on the menu" are those that appear
- when you press [alt-F2] while entering or editing transactions.
-
- 4.4.1.1 Defining Menu Transactions
-
- There are two ways to add a transaction "to the menu". One method is
- to "memorize" transactions as you enter or edit them (see the above
- sections about the "Utilities" menu). The other way is to select
- "Enter Auto Transactions" from the "Transactions" menu. You'll see
- another menu appear asking whether you want to add "menu" transactions
- or "date activated" transactions. Select "menu" (since we are
- defining "menu" transactions here).
-
- Next you'll see a familiar menu (asking for a transaction "type").
- These are the same options you have while entering "regular"
- transactions.
-
-
-
-
- CheckMate Plus Introductory User's Guide 38
-
-
-
-
-
-
- The "Enter Automatic Transactions" form is only slightly different
- than the "Enter Transactions" form:
-
- Check Number There is no field to enter a check number, since
- CheckMate Plus will assign one when you pick this
- transaction off the menu.
-
- Date You can't enter a date, since you'll assign a date
- when you select the transaction.
-
- Amount This is a special field for "automatic transactions".
-
- + TIMESAVER: If the amount for this transaction will
- routinely change (your utilities bill, for example),
- leave the amount zero and CheckMate Plus will
- automatically jump to the amount field when you
- select this transaction from the menu!
-
- Marked There is no "marked flag" for automatic transactions.
-
- Printed There is no "printed flag" for automatic
- transactions.
-
- Cleared There is no "cleared flag" for automatic
- transactions.
-
- Cleared Date You can't enter a cleared date, since "automatic
- transactions" can't "clear" until you pick them from
- the menu.
-
- Name At the bottom of the primary data entry screen, you
- can (and must) enter a "Name" for this automatic
- transaction. This Name will appear on the menu in
- alphabetical order. You may not have duplicate
- names!
-
- Important! Each "automatic transaction" is specific
- to the control account you have selected when you
- enter it. Each "automatic transaction" is also
- specific to the "transaction type" you're entering.
- You can have duplicate names as long as the
- duplicates are not in the same account and the same
- transaction type!
-
- This means, however, that an "automatic transaction"
- you put on the menu for one account WILL NOT appear
- on the menu for any other account.
-
-
-
-
- CheckMate Plus Introductory User's Guide 39
-
-
-
-
-
-
- + SPECIAL NOTE: CheckMate Plus orders the "names"
- alphabetically, but the names are CASE SENSITIVE.
- This means that "Tom" will appear BEFORE "anna"
- (since an upper-case "T" is alphabetically before a
- lower-case "a"). "Anna", however, will come before
- "Tom" (as long as "Anna" begins with a capital "A").
-
- CheckMate Plus also displays a highlighted bar at the bottom of the
- screen to remind you that you're entering an "automatic transaction"
- (versus a regular one).
-
- Remember you can also predefine the "split" (press [F3]), the "stub"
- (press [F4]), and the "notes" (press [alt-F4]).
-
- + TIMESAVER: You can "pop the menu up" while entering "automatic
- transactions" (just as you can while entering "regular" transactions).
- Just press [alt-F2]. This can save you time if you're entering
- multiple (but similar) automatic transactions.
-
- The "Utilities" menu is available while entering "automatic
- transactions". Press [F2] to pop it up.
-
- Press [F10] to save the automatic transaction after you've finished
- entering your data. It will now appear "on the menu" for this account
- and transaction type. Press [ESC] to abort saving.
-
- 4.4.1.2 Editing Menu Transactions
-
- If you want to "edit" your menu transactions, select "Edit Auto
- Transactions" from the "Transactions" menu, and then select "menu"
- from the next menu that pops up.
-
- CheckMate Plus will take you to the first "menu transaction" that
- you've defined for this account. Just as while editing "regular"
- transactions, you have the following "movement" keys available to you:
-
- [F7] This key moves backwards one transaction.
-
- [F8] This key moves forward one transaction.
-
- [F5] This key "jumps" to the first automatic transaction.
-
- [F6] This key "jumps" to the last automatic transaction.
-
- Since "menu transactions" don't have "dates" associated with them,
- CheckMate Plus orders them alphabetically by name. CheckMate Plus
- also orders them by transaction type. This means that all checks will
- appear first, followed by withdrawals, deposits, etc.
-
-
-
- CheckMate Plus Introductory User's Guide 40
-
-
-
-
-
-
- You can edit the menu transaction just as you do "regular"
- transactions. The "stub", "notes", and "split" windows are all
- available. You can also pop-up the "menu" with the [alt-F2] key, and
- the "Utilities" with the [F2] key.
-
- Press [F10] to save your changes, or [ESC] to abort. You may delete
- the transaction altogether by pressing [F9]. If you've made changes
- and attempt to abort or move to another transaction (without saving
- the changes), CheckMate Plus will prompt you to confirm before letting
- you loose your work.
-
- 4.4.2 Date Activated Transactions
-
- "Date Activated" Transactions are transactions you "program" to to
- notify you when they need to be entered. This is really a slick
- feature, and one that we think you will greatly appreciate.
-
- CheckMate Plus will NOT activate ANY transaction unless you want it
- to! "Date activated" transactions simply "remind" you when they're
- due and help you enter the data. They will not become "real
- transactions" without your confirmation.
-
- You have several options while programming these entries. Obviously,
- you can enter a "date" on which the transaction will become "active"
- (that is, when it's due). But you can also set the transaction to
- "repeat" after you enter it.
-
- For instance, suppose you set up a "date activated transaction" to
- remind you to pay your rent on June 26th. Since you pay rent every
- month, you can tell CheckMate Plus to automatically set the rent
- payment to recur on July 26th (and then August 26th, September 26th,
- etc). This would be "monthly" repeat.
-
- CheckMate Plus has six "repeat options". They are:
-
- o Never (Use once, and then ERASE the automatic transaction)
-
- o Monthly (Repeat on the same date every month)
-
- o Weekly (Repeat on the day every week)
-
- o Bi-Weekly (Repeat on the same day every two weeks)
-
- o Quarterly (Repeat on the same date every three months)
-
- o Yearly (Repeat on the same date every year)
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 41
-
-
-
-
-
-
- Repeat options have two basic types: "day" repeats (weekly and bi-
- weekly) and "date" repeats (monthly, quarterly, and yearly). "Day"
- repeats are "day" sensitive (Monday, Tuesday, etc) while "date"
- repeats are day of the month sensitive (1st, 2nd, 3rd, etc).
-
- + NOTE: Remember that some months have more "days" than others! If
- you want CheckMate Plus to remind you of a transaction on the last day
- of each month, be sure and enter "31st" even if the first month you
- enter doesn't have 31 days! In other words, it is perfectly legal to
- enter "Feb 31, 1990" as the date to activate a transaction. CheckMate
- Plus knows that February really doesn't have 31 days, and will
- "remind" you of this entry on the 28th. After you actually enter the
- transaction at the end of February, CheckMate Plus will update the
- activation date to "Mar 31, 1990".
-
- "Date activated transactions" are similar to "menu transactions". You
- have the same options while entering or editing them. Remember that
- if the "amount" changes from entry to entry, leave that field "zero"
- and CheckMate Plus will jump to it automatically (so you can enter the
- actual amount).
-
- + TIP: If you have a transaction that occurs "semi-monthly", make TWO
- monthly entries. For instance, members of the Armed Forces are paid
- twice a month (on the 1st and 15th). This is NOT the same as "bi-
- weekly". To make this work, enter TWO monthly transactions, the first
- one to activate on the 1st and the second one on the 15th.
-
- 4.4.2.1 Defining Date Transactions
-
- Just as with "menu transactions", there are two ways to enter a "date
- activated transaction". One method is to "memorize" transactions as
- you enter or edit them (see the above sections about the "Utilities"
- menu). The other way is to select "Enter Auto Transactions" from the
- "Transactions" menu. You'll see another menu appear asking whether
- you want to add "menu" transactions or "date activated" transactions.
- Select "date activated".
-
- Next you'll see a familiar menu (asking for a transaction "type").
- These are the same options you have while entering "regular"
- transactions.
-
- The "Enter Automatic Transactions" form is only slightly different
- than the "Enter Transactions" form:
-
- Check Number There is no field to enter a check number, since
- CheckMate Plus will assign one as you pick this
- transaction off the menu.
-
-
-
-
- CheckMate Plus Introductory User's Guide 42
-
-
-
-
-
-
- Date You can't enter a date, since the date will depend
- upon when you elect to activate the transaction.
-
- Amount This is a special field for "automatic transactions".
-
- + TIMESAVER: If the amount for this transaction will
- routinely change (your utilities bill, for example),
- leave the amount zero and CheckMate Plus will
- automatically jump to the amount field when you
- select this transaction from the menu!
-
- Marked There is no "marked flag" for automatic transactions.
-
- Printed There is no "printed flag" for automatic
- transactions.
-
- Cleared There is no "cleared flag" for automatic
- transactions.
-
- Cleared Date You can't enter a cleared date, since "automatic
- transactions" can't "clear" until you activate them.
-
- Repeat At the bottom of the primary data entry screen, you
- can enter a "repeat option". The different options
- are discussed above.
-
- This is a menu field. You can type the option in, or
- press [alt-F10] (or the middle button on the mouse)
- to pop the menu up.
-
- Important! Each "automatic transaction" is specific
- to the control account you have selected when you
- enter it. This means a "date activated" transaction
- will only activate for the account that is the
- control account when you enter it.
-
- CheckMate Plus also displays a highlighted bar at the bottom of the
- screen to remind you that you're entering an "automatic transaction"
- (versus a regular one).
-
- Remember you can also predefine the "split" (press [F3]), the "stub"
- (press [F4]), and the "notes" (press [alt-F4]).
-
- + TIMESAVER: You can "pop the menu up" while entering "automatic
- transactions" (just as you can while entering "regular" transactions).
- Just press [alt-F2]. This can save you time if you're entering
- multiple (but similar) automatic transactions.
-
-
-
-
- CheckMate Plus Introductory User's Guide 43
-
-
-
-
-
-
- The "Utilities" menu is available while entering "automatic
- transactions". Press [F2] to pop it up.
-
- Press [F10] to save the automatic transaction after you've finished
- entering your data. CheckMate Plus will now "remind" you when it is
- due. Press [ ESC] to abort saving the automatic transaction.
-
- 4.4.2.2 Editing Date Transactions
-
- If you want to "edit" your date activated transactions, select "Edit
- Auto Transactions" from the "Transactions" menu, and then select "date
- activated" from the next menu that pops up.
-
- CheckMate Plus will take you to the first "date activated transaction"
- that is scheduled to activate for the control account. Enteries are
- sorted first by transaction type (check, deposit, etc) and then by
- "activation date", so the first transaction you see may not actually
- be the next one to activate. Just as while editing "regular"
- transactions, you have the following "movement" keys available to you:
-
- [F7] This key moves backwards one transaction.
-
- [F8] This key moves forward one transaction.
-
- [F5] This key "jumps" to the first automatic transaction.
-
- [F6] This key "jumps" to the last automatic transaction.
-
- You can edit the menu transaction just as you do "regular"
- transactions. The "stub", "notes", and "split" windows are all
- available. You can also pop-up the "menu" with the [alt-F2] key, and
- the "Utilities" with the [F2] key.
-
- Press [F10] to save your changes, or [ESC] to abort. You may delete
- the transaction altogether by pressing [F9]. If you've made changes
- and attempt to abort or move to another transaction (without saving
- the changes), CheckMate Plus will prompt you to confirm before letting
- you loose your work.
-
- 4.4.2.3 Automatic "Reminder"
-
- CheckMate Plus automatically searches for due (and overdue)
- transactions each time you start the program. It will pop up the
- "Reminder Window" if it finds any. The "Reminder Window" lists the
- account with transactions due (or overdue) and asks you whether or not
- you want to process the transactions on the spot. Just answer YES or
- NO.
-
-
-
-
- CheckMate Plus Introductory User's Guide 44
-
-
-
-
-
-
- A separate "Reminder Window" will appear for each account that needs
- processing.
-
- If you select "YES", CheckMate Plus will run the date activated
- "script". You'll see each due transaction appear one at a time. You
- may modify them if you wish. Press [F10] to save each transaction
- (and CheckMate Plus will update its "activation date"), [F7] to "skip"
- a transaction (if you do this, CheckMate Plus will NOT update its
- "activation date"), or [ESC] to stop running the script.
-
- Once you've gone through all of the due transactions (or have pressed
- [ ESC]), CheckMate Plus will automatically return to the main menu.
-
- If you opt NOT to process the transactions, CheckMate Plus will
- continue to "remind" you every time you run the program until you
- either process the transactions, change their activation date, or
- delete them (see "Editing Date Transactions" above).
-
- 4.4.2.4 "AUTOEXEC.BAT" Reminder
-
- Registered copies of CheckMate Plus come with a small "command line"
- utility called "REMINDER.EXE". REMINDER scans your CheckMate Plus
- index file (CMPLUS.IX) looking for any transactions that are due and
- will display a simple screen message (and pause) if it finds any.
-
- If you place REMINDER in your AUTOEXEC.BAT file, it will remind you
- when you have transactions due every time you turn your computer on
- (without having to run CheckMate Plus).
-
- Remember, this utility comes on a bonus disk when you REGISTER your
- copy of CheckMate Plus!
-
- 4.4.3 Running Scripts
-
- You can run the "menu" and "date activated" transactions as "scripts".
- Scripts "move through the list of entries" one by one. You may modify
- each transaction as you go. Press [F10] to save the transaction,
- [F7] to "skip" this transaction, or [ESC] to stop running the script.
-
- Once you've gone through all of the due transactions (or have pressed
- [ ESC]), CheckMate Plus will automatically return you to the
- "Transactions" menu.
-
- 4.4.3.1 Menu Script
-
- Select "Run Automatic Scripts" from the "Transactions" menu, and then
- select "menu". CheckMate Plus will step you through all of the menu
- transactions for the control account.
-
-
-
- CheckMate Plus Introductory User's Guide 45
-
-
-
-
-
-
- 4.4.3.2 Date Script
-
- Select "Run Automatic Scripts" from the "Transactions" menu, and then
- select "date activated". CheckMate Plus will step you through all of
- the "date activated" transactions that are due (or overdue) for the
- control account.
-
- If you press [F10] to save the transaction, CheckMate Plus will update
- its "activation date" (see "Date Activated" transactions above.
-
-
- 4.5 The Browse Window
-
-
- CheckMate Plus has a "browse" feature which lets you view your
- transactions in a "check ledger" format (one line per transaction).
- Select "Browse Transactions" from the "Browse" window.
-
- 4.5.0.1 Activating the Browse Window
-
- Before you can start browsing, CheckMate Plus presents you with a
- "Browse Setup Window". You can do two things in this window: set
- browse dates and the "search and filter" pattern.
-
- Browse Dates You can enter the "starting" and "ending" browse
- dates before browsing. CheckMate Plus sets up the
- browse window by searching through the database for
- "matches" (see below). Setting the date boundaries
- can significantly reduce the file accesses that
- CheckMate Plus has to make and speed things up
- significantly.
-
- If you leave the dates blank, CheckMate Plus will
- search the entire file.
-
- Search and Filter
- Press [F2] in the "Browse Setup Window" to activate
- the "search and filter" window. You can enter a
- pattern here (every transaction the browser presents
- must match this pattern). Remember that the "search
- and filter" pattern is not active unless you turn it
- on ([alt-F] toggles the "filter flag"). While
- the filter is active, the word "FILT" appears on the
- "top line" of the screen.
-
- Once you've set up for the browse, press [F10]. CheckMate Plus will
- search the database and then open the "Browse Window".
-
-
-
-
- CheckMate Plus Introductory User's Guide 46
-
-
-
-
-
-
- The "Browse Window" lists each transaction on a single line. The
- following keys will move you around in the window:
-
- Up Arrow Move up one transaction.
-
- Down Arrow Move down one transaction.
-
- [PgUp] Move up on screen.
-
- [PgDn] Move down one screen.
-
- [Home] Move to first transaction.
-
- [End] Move to last transaction.
-
- The mouse will also move you through the transaction list.
-
- You can press the [SPACE BAR] while browsing to "mark" transactions.
- CheckMate Plus actually sets the "marked" flag to YES when you do
- this. This is useful if you want to mark transactions for a report
- (using the "search and filter" to only print "marked" transactions).
-
- If you press [ESC] in the "Browse Window" CheckMate Plus will return
- you to the "Transactions" menu.
-
- 4.5.0.2 Editing while Browsing
-
- At any time while you're browsing, you can press [CR] (or the left
- button on the mouse) to edit the currently highlighted transaction.
- The "Edit Transaction Window" will appear. Press [ESC] to return to
- the browser.
-
-
- 4.6 Closing Transactions
-
-
- CheckMate Plus lets you maintain active transactions indefinitely.
- Over time, however, CheckMate Plus' performance will decrease as it
- constantly has to search an ever larger database.
-
- As the necessity to maintain "old data" decreases (the data may be
- several years old, you may want to "close" the older transactions.
-
- Select "Close Transactions" from the "Transactions" menu to pop-up the
- "Close Transactions Window".
-
- You have a single option here (the PURGE date). Enter a date here and
- press [F10]. Since you can't reverse this procedure, CheckMate Plus
-
-
-
- CheckMate Plus Introductory User's Guide 47
-
-
-
-
-
-
- won't accept a default date (you must enter a valid date) and will
- prompt you to confirm your intentions before proceeding.
-
- The purge will erase all transactions prior to the "purge date".
- CheckMate Plus then updates the opening balance and opening dates of
- all accounts. If you have "closing" accounts (for REVENUE and
- EXPENSES) specified (see "Fiscal Year Information" in chapter 13),
- CheckMate Plus will transfer all REVENUE and EXPENSE balances to them
- as it purges the transactions.
-
- This procedure affects ALL accounts, not just the control account! It
- would be a good idea to make a backup before you proceed!
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 48
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 5
-
- Reports
-
-
- CheckMate Plus has many reports and many options for each report.
- Some of these options (such as margins, page size, printer setups,
- etc) are common for all and are discussed in the next chapter, "Report
- Printing Options".
-
- In this chapter, we'll describe most of the general purpose reports
- you can print and zero in on their unique options.
-
-
- 5.1 The Transaction Report
-
-
- The "Transaction Report" is account specific. This is what you'd call
- your checkbook ledger (for checking accounts... you can print this
- report for other accounts as well).
-
- This report acts on the control account only. Select the account you
- want to report on (from the "Accounts" menu) before printing.
-
- Select "Transaction" from the "Reports" menu. CheckMate Plus will
- present another menu with some "date range" options.
-
- Month Select "Month" to limit the report to a specific
- month and year. You can specify a particular month
- before printing.
-
- Year This option will print all transactions within an
- accounting (or fiscal) year. You set the fiscal year
- in the "Fiscal Year Setup Window" under the "Setups"
- menu. You can change the year before you print.
-
- 1st-4th Quarter Select any of the four quarters to limit the report
- to a specific three month period within the current
- fiscal year. You set the fiscal year in the "Fiscal
- Year Setup Window" under the "Setups" menu.
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 49
-
-
-
-
-
-
- Between Any Two Dates
- Select this option if you want to specify the range
- of dates that will appear on the report. This is the
- most flexible option.
-
- After you've selected a "date range", CheckMate Plus will take you to
- the "Transaction Report Window". Set any options you wish, and then
- print the report by pressing [F10]. See the next chapter "Report
- Printing Options" for much more information about the options
- available.
-
- 5.1.0.1 Customizing
-
- CheckMate Plus lets you "customize" the Transaction report to some
- degree. Press [F3] while you're in the "Transaction Report Window"
- and CheckMate Plus will pop up the "Customize Transaction Report
- Window".
-
- Here you can specify the fields you want to appear on each line and
- how much space each field will take. If you don't want a particular
- field to appear, set its length to "zero". Amounts are "right-
- justified" in their fields.
-
- CheckMate Plus computes the characters per line you'll need for the
- report. Make sure you set the "Report Parameters" correctly (see next
- chapter, "Report Printing Options"). Press [F10] to save your
- customizations to disk. [ ESC] takes you back to the "Transaction
- Report Window".
-
-
- 5.2 General Ledger Reports
-
-
- Unlike the "Transaction" report discussed above, the "General Ledger
- Reports" present information on ALL (detail) accounts you've defined.
- When you select "Ledger" from the "Reports" menu, you'll see another
- menu with three choices:
-
- The "Ledger Activity" report lists each account and its activity for
- the specified period. The "Ledger Transaction" report displays each
- transaction in ledger form (much like the "Split" window you see while
- entering transactions). The "Chart of Accounts" menu is simply a
- listing of all your ledger accounts (in logical order).
-
- 5.2.1 The Ledger Activity Report
-
- After you pick "Activity Report" from the Ledger Reports menu, you'll
- be prompted to specify a "date range" for the report.
-
-
-
- CheckMate Plus Introductory User's Guide 50
-
-
-
-
-
-
- Date Ranges:
-
- Month Select "Month" to limit the report to a specific
- month and year. You can specify a particular month
- before printing.
-
- Year This option will print all activity within an
- accounting (or fiscal) year. You set the fiscal year
- in the "Fiscal Year Setup Window" under the "Setups"
- menu. You can change the year before you print.
-
- 1st-4th Quarter Select any of the four quarters to limit the report
- to a specific three month period within the current
- fiscal year. You set the fiscal year in the "Fiscal
- Year Setup Window" under the "Setups" menu.
-
- Between Any Two Dates
- Select this option if you want to specify the range
- of dates that will appear on the report. This is the
- most flexible option.
-
- After you've selected a "date range", CheckMate Plus will take you to
- the "Ledger Activity Report Window". You can also limit the range of
- accounts that will appear on the report.
-
- + NOTE: CheckMate Plus must search the database (between the date
- ranges) once for each account to be printed. If you have a lot of
- accounts and a lot of transactions, CheckMate Plus may have to work a
- long time to set up the report. Narrowing both the date range and the
- account range can speed things up considerably.
-
- Set any options you wish, and then print the report by pressing [F10].
- See the next chapter "Report Printing Options" for much more
- information about the options available.
-
- 5.2.2 The Ledger Transaction Report
-
- After you pick "Transaction Report" from the Ledger Reports menu,
- you'll be prompted to specify a "date range" for the report.
-
- Date Ranges:
-
- Month Select "Month" to limit the report to a specific
- month and year. You can specify a particular month
- before printing.
-
- Year This option will print all transactions within an
- accounting (or fiscal) year. You set the fiscal year
-
-
-
- CheckMate Plus Introductory User's Guide 51
-
-
-
-
-
-
- in the "Fiscal Year Setup Window" under the "Setups"
- menu. You can change the year before you print.
-
- 1st-4th Quarter Select any of the four quarters to limit the report
- to a specific three month period within the current
- fiscal year. You set the fiscal year in the "Fiscal
- Year Setup Window" under the "Setups" menu.
-
- Between Any Two Dates
- Select this option if you want to specify the range
- of dates that will appear on the report. This is the
- most flexible option.
-
- After you've selected a "date range", CheckMate Plus will take you to
- the "Ledger Transaction Report Window".
-
- Set any options you wish, and then print the report by pressing [F10].
- See the next chapter "Report Printing Options" for much more
- information about the options available.
-
- 5.2.3 The "Chart of Accounts" Report
-
- Pick "Chart of Accounts" from the Ledger Reports menu to print a
- listing of all your accounts (including summary accounts).
-
- Each account's number and name are listed in this report (and also
- whether the account is a "debit" or "credit" account).
-
- Set any options you wish, and then print the report by pressing [F10].
- See the next chapter "Report Printing Options" for much more
- information about the options available.
-
-
- 5.3 Summary Reports
-
-
- "Summary" reports "summarize" the activity of all your accounts into
- two specific reports:
-
- o Balance Sheets
-
- o Income Statements
-
- "Balance Sheets" are like a "snapshot" of your account balances on a
- specific date.
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 52
-
-
-
-
-
-
- "Income Statements" (also called "Profit/Loss Statements") show the
- change in your account balances between two dates. Income statements
- are generally only concerned with REVENUE and EXPENSE accounts.
-
- Select "Summary" from the "Reports Menu". You can then pick either
- "Balance Sheet" or "Income Statement".
-
- 5.3.1 The Balance Sheet
-
- When you pick "Balance Sheet" from the Summary Reports menu, CheckMate
- Plus gives you yet another menu with three choices, a "standard"
- balance sheet, a "custom" balance sheet, and a "trial balance".
-
- 5.3.1.1 The Standard Balance Sheet
-
- CheckMate Plus will generate a "textbook" balance sheet when you pick
- this option. You'll see the "Balance Sheet Report Window" and will
- have two specific options (in addition to the ones common in all
- reports). First, you must specify a date for the balance sheet
- (remember, this is a "snapshot" of account balances on that date!).
- You can also have CheckMate Plus display account numbers (before each
- account name) on the report.
-
- Press [F10] to print the report. See the chapter "Report Printing
- Options" for more information on formatting and controlling the
- report.
-
- 5.3.1.2 Customized Balance Sheets
-
- If you prefer to design your own balance sheet, you can do so in
- CheckMate Plus. (See chapter 7, "Designing Custom Reports"). In
- fact, you can design up to forty different balance sheets.
-
- Selecting "Custom" from the Balance Sheet menu will pop up a menu of
- balance sheets you've defined. Pick the one you want, and you'll find
- yourself in the "Custom Report Window". See chapter 6 ("Report
- Printing Options") for a complete discussion on printing and
- formatting the report.
-
- [F10] prints the report, [ESC] backs you up one menu.
-
- + NOTE: Even though we call these "custom BALANCE SHEETS", you can
- really design any type of report you wish. The difference between a
- "balance sheet" and an "income statement" is primarily the calculation
- that take place. Balance sheets report balances on a specific date,
- while income statements report activity (or the change in balance)
- between two dates. When you design your custom reports, keep this
- distinction in mind, and select the model that fits your requirement.
-
-
-
- CheckMate Plus Introductory User's Guide 53
-
-
-
-
-
-
- 5.3.1.3 The Trial Balance
-
- Select "Trial Balance" from the Balance Sheet menu to print a
- "textbook" trial balance. The trial balance simply lists ALL (detail)
- accounts and their balance (as of the date you enter).
-
- Since the purpose of the trial balance is to make sure that
- debits=credits for all accounts, CheckMate Plus omits account number
- 39999 (Non-Accounted for Funds) from this report.
-
- Press [F10] to print the report.
-
- 5.3.2 The Income Statement
-
- When you pick "Income Statement" from the Summary Reports menu,
- CheckMate Plus gives you yet another menu with two choices, a
- "standard" income statement or a "custom" income statement.
-
- 5.3.2.1 The Standard Income Statement
-
- As with the balance sheet (above), CheckMate Plus will generate a
- "textbook" income statement when you pick this option.
-
- Since income statements report balance changes between two dates,
- CheckMate Plus will ask you for a "date range" (by popping up the
- "date range" menu).
-
- Date Ranges:
-
- Month Select "Month" to create an income statement for a
- specific month and year. You can specify a
- particular month before printing.
-
- Year This option will print an income statement for an
- entire fiscal year. You set the fiscal year in the
- "Fiscal Year Setup Window" under the "Setups" menu.
- You can change the year before you print.
-
- 1st-4th Quarter Select any of the four quarters to limit the report
- to a specific three month period within the current
- fiscal year. You set the fiscal year in the "Fiscal
- Year Setup Window" under the "Setups" menu.
-
- Between Any Two Dates
- Select this option if you want to specify the range
- of dates for the income statement. This is the most
- flexible option (but you can't generate any budget
- information).
-
-
-
- CheckMate Plus Introductory User's Guide 54
-
-
-
-
-
-
- Once you've picked a "date range", you'll see the "Income Statement
- Report Window" and will have some specific options (in addition to the
- ones common in all reports and the specific date range). First, you
- can have CheckMate Plus display account numbers (before each account
- name) on the report. You can also tell CheckMate Plus to display
- "budget information".
-
- The "budget information" CheckMate Plus displays is the ratio of the
- account's ACTUAL balance versus its BUDGETED balance (for the same
- "date range"). You enter the budget information while you define or
- edit each account (under the "Accounts" menu).
-
- Press [F10] to print the report. See Chapter 6, "Report Printing
- Options", for more information on formatting and controlling the
- report.
-
- 5.3.2.2 Customized Income Statements
-
- If you prefer to design your own income statement, you can do so in
- CheckMate Plus. (See chapter 7, "Designing Custom Reports"). In
- fact, you can design up to forty different income statements.
-
- Selecting "Custom" from the Income Statement menu will pop up a menu
- of income statements you've defined. Pick the one you want, and
- you'll find yourself in the "Custom Report Window". See chapter 6
- ("Report Printing Options") for a complete discussion on printing and
- formatting the report.
-
- [F10] prints the report, [ESC] backs you up one menu.
-
- + NOTE: Even though we call these "custom INCOME STATEMENTS", you can
- really design any type of report you wish. The difference between a
- "balance sheet" and an "income statement" is primarily the calculation
- that takes place. Balance sheets report balances on a specific date,
- while income statements report activity (or the change in balance)
- between two dates. When you design your custom reports, keep this
- distinction in mind, and select the model that fits your requirement.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 55
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 56
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 6
-
- Report Printing Options
-
-
- This chapter details the options you have for formatting and
- generating reports. For specifics on the reports themselves, see the
- previous chapter ("Reports").
-
-
- 6.1 Report Options
-
-
- Every report you can generate in CheckMate Plus has an "options"
- window associated with it. Among other report specific options
- (discussed along with the reports themselves), here are the general
- options you'll have available:
-
- o Report Date
-
- o Print to Screen, Printer, or File
-
- o Report Title
-
- o Report Footer
-
- Let's take a closer look at these different options...
-
- 6.1.1 Date
-
- The "Report Date" is the date CheckMate Plus will print on the title
- line of the report. It has nothing to do with the data in the report!
- It is simply meant to show when the report was generated. The default
- is the current (DOS) date.
-
- 6.1.2 "Print To" Options
-
- CheckMate Plus lets you print your reports to the screen (which we
- call "virtual paper"), your printer, or to a disk file in ASCII
- format.
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 57
-
-
-
-
-
-
- To select your printing option, move the cursor to the "Print To"
- field and type "Screen", Printer", or "File". This is a "menu field",
- so you can also press [alt-F10] (or the center button on the mouse) to
- pop the menu up.
-
- 6.1.2.1 To the Screen
-
- One problem with printing reports to the screen is that the screen is
- often too narrow to show the complete report. CheckMate Plus uses
- Virtual Paper to display reports on the screen.
-
- When you select printing "to the screen", CheckMate Plus formats the
- report exactly as if you were printing to the printer (including
- titles, footers, and margins). CheckMate Plus then opens the "Virtual
- Paper" window, and writes the report there.
-
- Virtual Paper displays as much of the report as it can (in the
- window). If each line is longer than you you can see on screen, you
- can scroll the window (with the left/right arrow keys, the TAB keys,
- or the mouse).
-
- You can also scroll the window up and down with the up/down arrow
- keys, [ PgUp], [PgDn], [Home], [End], or the mouse.
-
- CheckMate Plus presents the "highlighted bar" as a straight edge for
- your use while viewing the report.
-
- Virtual Paper is a marvelous tool for viewing reports prior to
- spending lots of time (and money) printing them to paper. The only
- drawback is memory usage. In order to allow forward and backward
- scrolling, CheckMate Plus must store the entire report in memory.
- This can take lots of your precious RAM!
-
- Fortunately, CheckMate Plus uses on the fly "run length encoding" of
- white spaces to dramatically reduce the memory requirements for most
- reports. Also, CheckMate Plus releases memory that it doesn't need
- (in fact, CheckMate Plus is constantly allocating and deallocating
- memory throughout the program operation).
-
- Obviously, the more RAM available to CheckMate Plus the less likely
- you'll see CheckMate Plus complain. But even with as little as 512K
- bytes available, CheckMate Plus should be able to handle all but the
- largest reports in Virtual Paper.
-
- 6.1.2.2 To the Printer
-
- Select "Printer" in the "Print To" field to generate a hard copy of
- your report. You can change the printer port (LPT1, LPT2, COM1, and
-
-
-
- CheckMate Plus Introductory User's Guide 58
-
-
-
-
-
-
- COM2) in the "Report Parameters" window (see next section, "Report
- Parameters").
-
- + NOTE: If you tell CheckMate Plus to print to a printer that is off,
- off-line, or doesn't even exist, what will happen next depends on YOUR
- COMPUTER and your ROM BIOS. Some computers will return execution to
- CheckMate Plus. CheckMate Plus then displays an appropriate message
- and stops trying to print. Other computers will simply "hang" until
- you fix the problem (i.e. turn on the printer, etc). You may have to
- "reboot" your system if your computer does this (and there is NOTHING
- that CheckMate Plus can do about it!).
-
- 6.1.2.3 To a File
-
- If you want to write the formatted report to a disk file in ASCII
- format, enter "File" in the "Print To" field before you start
- printing.
-
- You'll have to enter a legal DOS filename in the "File Name" field.
- You can specify the entire name, including a "path" (in the space you
- have available). CheckMate Plus will promptly notify you if it can't
- create the report file.
-
- 6.1.3 Title
-
- The report "Title" appears on the title line (just below
- company/personal information and on the same line as the report date).
- You can enter this title in the "Report Title" field.
-
- Some reports "pre-initialize" the title. If so, you can change it
- before you start printing.
-
- 6.1.4 Footer
-
- The report "Footer" appears at the bottom of every page (on the same
- line as the page number). You can customize the footer in the "Report
- Footer" field.
-
- 6.1.5 The "Utility" Menu
-
- While you're setting your report options (before you print the
- report), you can pop a "utility" menu up by pressing [F2].
-
- The "utility" menu has two options: "Set Report Parameters" and "Set
- Search and Filter". These options are discussed in detail in the
- following sections.
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 59
-
-
-
-
-
-
- 6.2 Report Parameters
-
-
- When you select "Set Report Parameters" from the "Utilities" menu, the
- "Report Parameters Setup Window" will appear.
-
- The "Report Parameters" let you set items such as margins, line
- lengths, the printer port, and any setup or exit control strings you
- want to send to your printer. We put these items in a separate (less
- accessible) window since we anticipate you won't be changing them very
- often. You can set default values for all these fields (see the
- chapter "Setup and Options").
-
- Margins You can set the "margins" (top, bottom, left, and
- right). Express the top and bottom margins as a
- number of lines, and the left and right margins as a
- number of characters.
-
- + NOTE: CheckMate Plus assumes that you're using
- "fixed width" fonts for your reports (rather than
- proportionally spaced fonts). Most printers do use
- (or at least have the option to use) fixed width
- fonts.
-
- CheckMate Plus does not support "postscript" printers
- at this time.
-
- Paper Sizes Paper size is a function of the number of lines per
- page you can print and the number of characters on
- each line. These numbers are absolute (i.e. they
- include margins).
-
- Most printers put 66 lines on a page. Many laser
- printers, however, require built-in top and bottom
- margins. The Hewlett Packard LaserJet, for example,
- can only print 60 lines per page.
-
- The number of characters per line you print will
- usually be determined by either the width of the
- paper (most paper is 8.5'' wide) or by the "pitch" of
- the print. For instance, if your printer has a
- "compressed" mode (17 characters per inch), you can
- print 132 characters on a standard letter-sized sheet
- of paper.
-
- + NOTE: You can use the "Printer Setup Strings"
- (discussed below) to "command" your printer into
- compressed mode.
-
-
-
- CheckMate Plus Introductory User's Guide 60
-
-
-
-
-
-
- Page Control You can tell CheckMate Plus to "pause" after each
- page to let you feed paper (if you're not using a
- laser printer or continuous feed paper).
-
- Printer Port CheckMate Plus lets you direct your printed reports
- to LPT1, LPT2, COM1, or COM2. Set your printer port
- in the "Printer Port for Reports" field. (This is a
- "menu field", so press [alt-F10] or the center mouse
- button to "pop" the menu up).
-
-
- Setup Strings CheckMate Plus lets you define printer "setup" and
- "exit" strings to control such things as margins,
- character pitch, attributes, etc. CheckMate Plus
- sends the "setup" strings to your printer before it
- starts the report and the "exit" strings after the
- report is completed.
-
- For instance, you may want to "command" your printer
- to print 17 characters per inch for some of the
- reports. You would enter the proper "control codes"
- in the "Printer Setup Strings" field.
-
- You'll probably want to use the "exit" strings to
- reset your printer (for normal operation).
-
- The printer control codes can be found in your
- printer manual. The format for entry is
-
- \<decimal code>\<decimal code>\....
-
- The back-slashes delimit the codes. Here is an
- example:
-
- \27\85
-
- This string represents an <ESC> 'U'. (That's an
- escape-capital-U). This is a popular means of
- defining printer codes.
-
- 6.2.1 Saving Report Parameters
-
- Press [F10] while in the "Report Parameters Setup Window" to save your
- setups for later use. CheckMate Plus will ask you for a name (to
- associate with the setups).
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 61
-
-
-
-
-
-
- 6.2.2 Retrieving Report Parameters
-
- To retrieve a set of previously defined parameters, press [F9] while
- in the "Report Parameters Setup Window". If you've previously saved
- any setups, CheckMate Plus will present you with a menu to select
- from.
-
- 6.2.3 Deleting Report Parameters from Disk
-
- To delete a setup you've previously saved, first "retrieve" the
- desired setup (as described above). Then press [F8]. CheckMate Plus
- will prompt you to confirm your intentions before actually deleting
- the setup.
-
-
- 6.3 "Search and Filter"
-
-
- Many reports search the transaction database. You can limit the
- search by setting a "search and filter" pattern for each transaction
- to "match". Select "Set Search and Filter" to pop-up the "Search and
- Filter" window.
-
- Remember that the "search and filter" pattern doesn't have any effect
- unless the "filter flag" is set. (The word "FILT" will appear on the
- "top line" of the screen when the filter flag is active. Press [alt-
- F] to toggle the filter flag on and off.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 62
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 7
-
- Designing Custom Reports
-
-
- CheckMate Plus has a host of built-in reports. You may, however, wish
- to customize some of them to meet your specific needs.
-
- You may customize your summary reports. These are the reports that
- show account balances and activity. In particular, you can customize
- two specific types of reports: balance sheets and income statements.
-
- You select the type of report you want to customize from the
- "Maintenance" menu. Pick either "Define Custom Balance Sheets" or
- "Define Custom Income Statement". Both selections will pop-up another
- menu with two options: "Enter new Report Definitions" or "Edit
- existing Report Definitions".
-
- If you select "edit", CheckMate Plus will present a menu of previously
- defined reports (if any exist). Select the report you want.
-
- + NOTE: Even though we call these "BALANCE SHEETS" or "INCOME
- STATEMENTS", you can really design any type of report you wish. The
- difference between a "balance sheet" and an "income statement" is
- primarily the calculation that takes place. Balance sheets report
- balances on a specific date, while income statements report activity
- (or the change in balance) between two dates. When you design your
- custom reports, keep this distinction in mind, and select the model
- that fits your requirement.
-
- You'll enter and edit your report definitions with CheckMate Plus'
- built in editor. (See Chapter 2 for more details). When you're done
- with your entries, press [F10] to save your definition to disk. Press
- [F9] to delete a definition that you're editing.
-
- The rest of this chapter is devoted to the actual report definition
- format.
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 63
-
-
-
-
-
-
- 7.1 Report Definition Format
-
-
- We've made every possible effort to make the report definition format
- as simple as possible in CheckMate Plus. We realize that a feature is
- not really useful unless people use it. We think you'll find
- CheckMate Plus' report definition format very easy to master.
-
- + NOTE: In any definition language, you must "trade off" flexibility
- with ease-of-use. In order to make the report definition language
- truly easy to use, we've restricted its flexibility somewhat. We hope
- we've hit the optimum balance.
-
- The report definition format is very simple. Essentially, all you
- have to do is type the report just as you want it to appear when you
- print it. Look at this example:
-
-
- This is a Test Balance Sheet.
-
- ASSETS
- Cash
- Checking Account
- Building
- -- etc --
-
- LIABILITIES
- Accounts Payable
- Salaries Payable
- -- etc --
-
- EQUITY
- -- etc --
- .end
-
-
- Here's how the report will look when CheckMate Plus prints it:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 64
-
-
-
-
-
-
- ------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ------------------------------------------------------------------
- Jul 5, 1990
- ------------------------------------------------------------------
-
-
- This is a Test Balance Sheet.
-
- ASSETS
- Cash
- Checking Account
- Building
- -- etc --
-
- LIABILITIES
- Accounts Payable
- Salaries Payable
- -- etc --
-
- EQUITY
- -- etc --
-
-
- Page 1
-
-
- Figure 7.1: A "Test" Custom Balance Sheet
-
- While you define the report, keep in mind that CheckMate Plus will put
- the text on the same lines and in the same columns as you enter them.
- It's that simple.
-
- Notice that we ended the report definition with ".end". The ".end"
- command tells CheckMate Plus when to end the report. You must place
- the command in column one. The ".end" won't show up on the report
- when you print it.
-
- 7.1.1 Account Balances
-
- Of course, the reports won't be of much use if you can't print actual
- values. CheckMate Plus makes this easy, too. To print an account's
- "balance" enter the account's number within brackets, like this:
-
-
-
- CheckMate Plus Introductory User's Guide 65
-
-
-
-
-
-
- {#1} or {#10000}
-
- The first expression will cause CheckMate Plus to print the balance of
- account #1 (ASSETS). The second expression prints the balance of
- account 10000. Notice the pound sign ("#") preceding the account's
- number.
-
- The "balance" will take up as much space as you allow with the
- brackets. If you want the balance to take up twelve spaces, for
- instance, enter the balance as such:
-
- {#1 }
-
- The number will be right-justified in the field (so you can line up
- columns of numbers) and will include commas and two digits after the
- decimal point. The length CheckMate Plus will print includes the
- brackets. (This makes it easy to design the report. Everything
- prints exactly as it appears while you enter it). Let's expand our
- earlier example to include the balances:
-
-
- This is a Test Balance Sheet.
-
- ASSETS {#1 }
- Cash {#10000 }
- Checking Account {#10001 }
- Building {#10002 }
- -- etc --
-
- LIABILITIES {#2 }
- Accounts Payable {#20000 }
- Salaries Payable {#20001 }
- -- etc --
-
- EQUITY {#3 }
- -- etc --
-
-
- Here's how our ammended report will look when CheckMate Plus prints
- it:
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 66
-
-
-
-
-
-
- ------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ------------------------------------------------------------------
- Jul 5, 1990
- ------------------------------------------------------------------
-
-
- This is a Test Balance Sheet.
-
- ASSETS 145,732.35
- Cash 1,685.11
- Checking Account 1,642.69
- Building 101,987.88
- -- etc --
-
- LIABILITIES 89,038.05
- Accounts Payable 1,345.00
- Salaries Payable 3,150.00
- -- etc --
-
- EQUITY 54,430.43
- -- etc --
-
-
- Page 1
-
- Figure 7.2: A "Test" Custom Balance Sheet with Account Values
-
- See how CheckMate Plus let's you line up the columns?
-
- + NOTE: Remember that the value CheckMate Plus will print depends upon
- the type of report you define. "Balance Sheets" will print the actual
- balance of the account (on the balance sheet date). "Income
- Statements" will print the change in the balance of the account
- between two dates.
-
- 7.1.2 Budget Information
-
- You can also have CheckMate Plus print budget information on the
- report. The format is identical to the "balances", except use a "%"
- instead of a "#" inside the brackets. For example,
-
- {%10000}
-
-
-
- CheckMate Plus Introductory User's Guide 67
-
-
-
-
-
-
- will CheckMate Plus to print budget information for account number
- 10000.
-
- CheckMate Plus prints the budget information as a percentage of the
- actual balance over the same period of time. The budget information
- really only makes sense for "Income Statements".
-
- 7.1.3 Calculations
-
- At times, you'll need to perform some calculations before printing.
- CheckMate Plus lets you "embed" calculations in the report.
-
- Suppose, for instance, that you need to calculate PROFIT for your
- Income Statement. Since PROFIT=REVENUE-EXPENSES, you can't derive
- profit from any one account's balance.
-
- If you start a line in the report definition with a period ("."),
- CheckMate Plus will treat that line as a calculation line (it won't
- print in the report). They work like this:
-
- .Profit=#4-#5
-
- "Profit" becomes a variable. Here we have assigned it the value of
- account number 4 (REVENUE) minus the value of account number 5
- (EXPENSES). You can then use "Profit" inside the braces (just like
- balances and budget information). Hence, these lines in the report
- will print the profit:
-
- .Profit=#4-#5
- Profit = {Profit }
-
- You can embed the "calculation lines" anywhere in the report, so long
- as column 1 has a period! The variables may be reused. You can even
- include numbers in the calculations. For example:
-
- .Total=100+#1-300/2
-
- This is a valid calculation line. The calculations can include
- multiplication ("*"), division ("/"), addition ("+"), and subtraction
- ("-"). The standard mathematical order of precedence applies, and you
- can use parentheses in the expression.
-
-
- 7.2 Tips on Designing Reports
-
-
- If you think about designing your reports for a minute, you can see
- how much flexibility you really have. You can enter any text you
-
-
-
- CheckMate Plus Introductory User's Guide 68
-
-
-
-
-
-
- want, and arrange the values to print alongside it. This means you
- can "summarize" the report as you see fit.
-
- Here's where "summary" accounts are particularly useful. Suppose, for
- instance, you have three bank accounts (numbered 10000, 10001, and
- 10002). You can define a summary account number 1000 and call it
- "Cash in Banks". Then you can define an report that would print out
- like this:
-
- 10000 First Bank 1,232.12
- 10002 Second Bank 756.55
- 10003 Third Bank 2,334.00
-
- Total 4,322.67
-
- Here's what the actual definition would look like:
-
- 10000 First Bank {#10000 }
- 10002 Second Bank {#10001 }
- 10003 Third Bank {#10002 }
-
- Total {#1000 }
-
- + IMPORTANT: Remember that for the above example to work properly, you
- can't have any accounts numbered 10003 through 10009! Refer to
- Chapter 3 for more information on "summary" accounts.
-
- You could also do the above summation with variables and calculation
- lines (see above).
-
- You can see that with a little imagination, you can design some very
- powerful and useful reports. You can create up to 40 "balance sheets"
- and up to 40 "income statements" for a total of 80 custom report
- definitions.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 69
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 70
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 8
-
- Reconciling Checking Accounts
-
-
- One of CheckMate Plus' most useful features is checking account
- reconciliation. CheckMate Plus goes beyond most checking account
- programs in that it can completely re-create bank statements at any
- time!
-
- CheckMate Plus does this by recording the date each transaction clears
- (and it does this automatically). Select "Reconcile" from the
- "Reports" menu to start reconciling (this option only appears on the
- menu if the current control account is a checking account).
-
- Checking account reconciliation is a four step process:
-
- o Enter the "statement" date from your bank statement. This is
- important!
-
- o Enter any "new" transactions (interest earned, service charges,
- or transactions you "missed" during the month).
-
- o Mark transactions that have cleared on this statement.
-
- o Print the "Reconciliation Report".
-
- 8.0.0.1 Your Statement Date
-
- Your first step is entering the statement date (from your bank
- statement). This is important because CheckMate Plus will save this
- date (in the "date cleared" field) for every transaction on the
- statement.
-
- The statement date should be clearly marked as such on your bank
- statement. Enter the date, and move on to step two (monthly events).
-
- 8.0.0.2 Monthly Events
-
- "Monthly events" are those transactions that appear on your statement
- every month (such as interest earned or service charges). After
- you've entered your "statement date", press [F3] to enter these
-
-
-
- CheckMate Plus Introductory User's Guide 71
-
-
-
-
-
-
- transactions (if you have any). CheckMate Plus pops up the familiar
- "enter transactions" form for you. You have all the features normally
- available (including the "pop-up menu" and "utilities").
-
- + IMPORTANT: Be sure and enter the correct date for these
- transactions! The date must be on or before the "statement date" or
- the transactions won't appear while "clearing" (see below).
-
- Repeat this step for each "monthly event" you need to enter. Then
- proceed to step three (clearing transactions).
-
- 8.0.0.3 Clearing Transactions
-
- Press [F4] to "clear" transactions. At this point, CheckMate Plus
- will search through the data file looking for transactions that have
- not cleared (dated before the statement date) and transactions that
- have already cleared on the statement date. Keep in mind that you may
- have transactions from long ago that have either not cleared (or have
- cleared on this date). If you have several years worth of data, be
- patient as CheckMate Plus searches the file! It's absolutely
- necessary.
-
- Once CheckMate Plus is done scanning the file, the "Reconcile Window"
- will appear. (This window is very similar to the "Browse Window).
- Each transaction takes one line. Transactions that have "cleared" are
- marked with "arrows" at each end.
-
- You should also check to see if any of the transactions on the
- statement come after that date. (Sometimes banks will show service
- charges or interest on the day following the statement date). If this
- is the case, then mark those transactions as occurring on the
- statement date.
-
- 8.0.0.4 The Reconciliation Report
-
- After you've marked every "cleared" transaction, you're ready to
- print the "Reconciliation Report". Because CheckMate Plus records the
- "date cleared" for every transaction, this report should have exactly
- the same information as your bank statement.
-
- Press [F10] to start the report process. CheckMate Plus has to search
- the entire file (from start to statement date) looking for
- transactions that may have "cleared" on this statement. If you have
- several years worth of data, this could take a few minutes.
-
- After CheckMate Plus has searched the file, the "Reconciliation Report
- Window" appears.
-
-
-
-
- CheckMate Plus Introductory User's Guide 72
-
-
-
-
-
-
- Set any options you wish and then press [F10] to print.
-
- The report should list all transactions that cleared on this bank
- statement. At the bottom of the report, CheckMate Plus will list six
- additional items:
-
- Balance Last Statement
- Balance This Statement
- Number of Checks and Debits
- Number of Deposits and Credits
- Total of Checks and Debits
- Total of Deposits and Credits
-
- Most bank statements also include these lines. If all is well, the
- numbers on the report should match you statement exactly. If not,
- carefully compare the report to the statement to track down the error.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 73
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 74
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 9
-
- Printing Checks
-
-
- In this chapter, we'll discuss how to use CheckMate Plus to print your
- checks. You can use pin-feed checks, laser checks, or even "single"
- checks right out of your checkbook!
-
- + NOTE: Before you can print any checks, you must have assigned a
- "check layout" to the account you're using. You do this while
- entering (or editing) accounts under the "Accounts" menu.
-
- You don't have to print every check. Many CheckMate Plus users print
- some checks and write others by hand. This is easy to do in CheckMate
- Plus... just make sure you manually set the "PRINTED" flag while
- you're entering (or editing) the checks you write by hand.
-
- + TIMESAVER: If you're not printing any checks (that is, you're
- writing them all by hand), just "ignore" the "PRINTED" flag! You
- don't have to set it to "YES".
-
-
- 9.1 Printing Your Checks
-
-
- You can print your checks at two different times: while you're writing
- them (one at a time) or in "batch". In either case, you'll have to
- properly align the check in the printer before printing. This may
- seem difficult at first (especially with individual checks), but it
- becomes second nature with a little practice.
-
- + SPECIAL NOTE: Most dot-matrix printers have "pull tractors", which
- means you have to feed and extra check up to the tractor each time you
- print. This means you must discard one check each time you print, and
- could mess up the check "numbers". If you're buying pin-feed checks
- for CheckMate Plus, we suggest you order them without preprinted check
- numbers (and let CheckMate Plus print the number on the check).
-
- You can only print checks from the currently active control account.
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 75
-
-
-
-
-
-
- 9.1.0.1 Printing while Editing
-
- At any time while you're entering (or editing) a check, you can print
- it by popping up the "utilities menu". The "print check" option
- appears. Select it to print your check immediately.
-
- Make sure your printer and check are ready before you select this
- option! CheckMate Plus prints the check immediately.
-
- After printing, CheckMate Plus will mark the check's "PRINTED" flag to
- "YES".
-
- 9.1.0.2 Printing in "Batch"
-
- If you so choose, you can have CheckMate Plus print all your checks
- at one time (in batch). Select "Print Checks" from the "Reports"
- menu. (The "Print Checks" option will only appear if the current
- control account is a checking account). CheckMate Plus will display
- the first check to print.
-
- At this point, you have some options. You may print each check (one
- at a time) by pressing the [SPACE BAR]. CheckMate Plus will pause
- between each one. (This is the way you'll want to print checks if
- you're feeding them into your printer one at a time).
-
- If you want to print all the checks one after another (without pausing
- between each one), press [F10]. You can press [F10] anytime, even if
- you've already printed some checks with the [SPACE BAR].
-
- If you discover you've already written a check that's to be printed,
- you can press [F2] to have CheckMate Plus mark it as printed without
- actually printing it! We added this feature in case you're mixing
- writing checks by hand and printing them. We suggest you manually
- mark the check as printed while you enter it. But if you forget, you
- can correct it here.
-
- Before CheckMate Plus can print any checks, it must "parse" the check
- layout and make sure there are no "syntax" errors. CheckMate Plus'
- check writing language is by far the most powerful in the industry,
- with many features and maximum flexibility. (See "Designing Your Own
- Check Layout" for more information).
-
- If CheckMate Plus finds an error in your check layout, the "Error in
- Check Layout" window appears (with an error message and error
- location). At this point you have two options. Press [F2] to
- immediately enter the "Editing Check Layout" window. CheckMate Plus
- will jump to the error. Make your corrections, press [F10] to save
- them, and CheckMate Plus returns to the task of printing your checks.
-
-
-
- CheckMate Plus Introductory User's Guide 76
-
-
-
-
-
-
- You can repeat this "loop" as many times as necessary to perfect your
- layout.
-
- Pressing any other key in the "Error in Check Layout" window causes
- CheckMate Plus to abort printing checks and return to the menu.
-
- Press [ESC] to abort printing checks. After CheckMate Plus has
- printed all your checks, you automatically return to the "Reports"
- menu.
-
-
- 9.2 Selecting a Check Layout
-
-
- Before you can print checks with CheckMate Plus, you must tell
- CheckMate Plus how your checks are "laid out". You can have up to 40
- unique check layouts. CheckMate Plus comes with three layouts
- preinstalled:
-
- o NEBS 9025 (pin-feed check with stub)
-
- o NEBS 9027 (laser printer check with stub)
-
- o NEBS 9029 (pin-feed check without stub)
-
- These checks are manufactured by New England Business Service, INC
- (NEBS). You received a package with this User's Guide containing
- information and an order form. If you didn't get one or you've
- misplaced it, call us at (719) 260-0402 and will send the complete
- package to you.
-
- You can modify these definitions, and even create your own! (See
- "Designing Your Own Check Layout" below). You may have up to 40
- definitions.
-
- You "assign" a check layout to each checking account while you enter
- (or edit the account). See "Chapter 3: Accounts" for more
- information.
-
-
- 9.3 Designing Your Own Check Layout
-
-
- To design or modify a check layout, select "Define Check Layout" from
- the "Maintenance" menu. You'll see another menu with two options:
- "Enter new Check Layout" or "Edit existing Check Layout".
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 77
-
-
-
-
-
-
- If you select "edit", CheckMate Plus will present a menu of previously
- defined layouts (if any exist). Select the layout you want.
-
- You'll enter and edit your check layouts with CheckMate Plus' built in
- editor. (See Chapter 2 for more details). When you're done with your
- entries, press [F10] to save your layout to disk. Press [F9] to
- delete a layout you're editing.
-
- The rest of this chapter is devoted to the check layout "language".
- CheckMate Plus' layout language is modeled after the "PASCAL"
- programming language. If you have any programming experience, you
- should have no trouble mastering the layout language. If you're a
- novice, or if you're uncomfortable with programming, you may want to
- find a more experienced friend to help you (or consider using one of
- the NEBS checks discussed above).
-
-
- 9.4 The Check Layout Language
-
-
- Defining a check layout is considerably different than designing a
- custom report. We wanted to give the user an unparalleled capability
- for spacing lines, changing fonts, and manipulating text and values as
- the check is being printed. To be able to do these types of things,
- you have to be able to issue "commands" to the printer rather than
- simply drawing a "template" of the check.
-
- 9.4.1 Reserved Words and Variables
-
- Let's start with a list of "reserved" words. These are the actual
- commands that CheckMate Plus expects in your layout. We'll detail
- each of these in subsequent sections.
-
- Begin End Page Pause
- NewCheck FillersOn FillersOff CommasOn
- CommasOff Column SkipLines Write
- Writeln Stub Variable PrintTo
- Input PrinterString
-
- Table 9.1: Check Layout Language Reserved Words
-
-
- You also have access to these built-in variables for each check.
- Again, we'll elaborate on each one later:
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 78
-
-
-
-
-
-
- Date Check Number PayTo For
- Vendor Acct# Comments Amount Tax Ded
- Marked Address 1 Address 2 Address 3
- Amount String
-
- Table 9.2: Check Layout Language Built-in Variables
-
-
- 9.4.2 Command Sequence
-
- The check layout language is a "free format language". The only
- ordering requirement is that each layout starts with the "begin"
- keyword and ends with the "end" keyword.
-
- begin
- .
- .
- (your layout here)
- .
- .
- end
-
- Notice that the "end" doesn't require a "." before it (as the report
- definitions do).
-
- In between the "begin" and "end", you can enter commands in any order
- you desire. You can have more than one command on a line. All
- commands are separated by semicolons (";"). Here's an example:
-
- begin
-
- SkipLines(8); column(10);
- FillersOn;
- write(Amount String,L,61,0);
- FillersOff;
-
- end;
-
- (We'll discuss what the actual commands do shortly). You can also
- embed comments in the layout. The comments are for your benefit --
- (they don't print or affect the printer in any way).
-
- Enter comments between braces ("{" and "}"). All comments must fit on
- a single line.
-
- begin
-
- SkipLines(8); {Start on line # 9}
-
-
-
- CheckMate Plus Introductory User's Guide 79
-
-
-
-
-
-
- column(10); {Start in column 10}
- FillersOn;
- write(Amount String,L,61,0);
- {write the spelled out amount}
- FillersOff;
-
- end;
-
-
- 9.4.3 A Simple Example
-
- Now let's generate a very simple example layout. Let's assume that
- our checks have the date on line 3 in column 55. We want to print the
- payee's name on line 6 in column 4 (and we have 40 spaces available to
- print in). After the payee's name (also on line 6) is the dollar
- amount of the check, starting in column 58 with 13 spaces available.
- Finally, we want to print the "spelled out amount" (such as Ten &
- 45/100 ***** dollars) on line 8. We'll start in column 4 and we have
- 64 spaces available.
-
- Here's the layout:
-
- begin
-
- SkipLines(2); {Start on line 3}
- column(55);
- writeln(Date,L,12,0); {Print the date}
-
- writeln; {Go to line 5}
- writeln; {Go to line 6}
-
- column(4);
- write(PayTo,L,40,0); {Write payee}
-
- FillersOn;
- column(58);
- write(Amount,R,13,0); {Write the amount}
-
- writeln; {Go to line 7}
- writeln; {Go to line 8}
-
- column(4);
- write(Amount String,L,64,0);
- FillersOff;
-
- SkipLines(6); {Eject the check}
-
- NewCheck; {Set up for next check}
-
-
-
- CheckMate Plus Introductory User's Guide 80
-
-
-
-
-
-
- end
-
-
- Now let's discuss each of the command:
-
- SkipLines(2) This command tells CheckMate Plus to skip the first
- two lines of the check and start on line 3.
-
- column(55) Now we're telling CheckMate Plus to advance to column
- 55 of the current line.
-
- writeln(Date,L,12,0)
- The "writeln" command instructs CheckMate Plus to
- write the date at the current column. The "12" means
- we have twelve spaces available in which to print the
- date. The "L" means to left-justify the date in the
- 12 character field. Finally, the "0" is an "option
- number". This number will have different meanings
- for different variables. Every time we do a writeln,
- we go to column one of the next line.
-
- writeln Next we did two writeln's (without any parameters).
- This just means that we'll skip two lines (we could
- also have used the "SkipLines" command again).
-
- column(4) Now we advance to column 4 to print the payee's name.
-
- write(PayTo,L,40,0)
- Like the "writeln" command, the "write" command
- prints the variable. But unlike the writeln, we do
- not advance to the next line after we're done!
-
- This command tells CheckMate Plus to print the
- payee's name left-justified in a 40 column field.
-
- FillersOn This command tells CheckMate Plus to "fill" blanks
- with asterisks ("*"). You'll see why when you look
- at the next two commands.
-
- column(58) Advance to column 58. We're still on the same line
- with the payee's name.
-
- write(Amount,R,13,2)
- This command writes the amount of the check. The "R"
- means right-justified in a 13 character field. Since
- fillers are on (see above), and leading blanks are
- converted to asterisks while it's printed. For
- example, "100.00" would appear as "*******100.00".
-
-
-
- CheckMate Plus Introductory User's Guide 81
-
-
-
-
-
-
- The "2" (in the options field) tells CheckMate Plus
- to print two digits after the decimal point.
-
- writeln Now we do two more writeln's to advance to line 8.
-
- column(4) Go to column 4.
-
- write(Amount String,L,64,0)
- This writes the "spelled out amount". The fillers
- are still on, so the asterisks will fill in all
- trailing blanks.
-
- FillersOff Turn fillers off for the next check.
-
- SkipLines(6) Push the current check out.
-
- NewCheck This command resets CheckMate Plus' internal counters
- for the next check.
-
- Are you getting the idea? Now let's look at CheckMate Plus' layout
- commands in more detail.
-
- 9.4.4 Layout Commands
-
- 9.4.4.1 Begin
-
- The "Begin" command takes no arguments. You must start each layout
- with a "Begin". Also, you don't place a semicolon after the "begin".
-
- Example:
-
- begin
-
-
- 9.4.4.2 Column(<column number>)
-
- The "Column" command takes one argument (the column you want to move
- to).
-
- Example:
-
- column(10);
-
- + NOTE: If you're already past the desired column, CheckMate Plus
- issues a carriage return without a line feed (to return to column 1)
- and then moves to the correct column. Some printers will
- automatically advance one line when they receive a carriage return
- without a line feed. Others printers will ignore the return and stay
-
-
-
- CheckMate Plus Introductory User's Guide 82
-
-
-
-
-
-
- at the same column. The best thing to do is avoid the circumstances
- that would cause CheckMate Plus to issue the carriage return.
-
-
- 9.4.4.3 CommasOff
-
- "CommasOff" takes no arguments. This command causes all subsequent
- numbers to be printed without commas. For instance, the number
- "1,454,778.45" would appear as "1454778.45".
-
- Example:
-
- CommasOff;
-
-
- 9.4.4.4 CommasOn
-
- "CommasOn" takes no arguments. This command causes all subsequent
- numbers to be printed with commas.
-
- Example:
-
- CommasOn;
-
-
- 9.4.4.5 End
-
- The "End" command takes no arguments. You must end each layout with
- the "End" command. The "End" command does not have a semicolon after
- it.
-
- Example:
-
- end
-
-
- 9.4.4.6 FillersOff
-
- "FillersOff" takes no arguments. This command causes all subsequent
- variables and text to be printed with "blanks" in the unused space.
- To better understand, look at "FillersOn" below.
-
- Example:
-
- FillersOff;
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 83
-
-
-
-
-
-
- 9.4.4.7 FillersOn
-
- "FillersOn" takes no arguments. This command causes all subsequent
- variables and text to be printed with asterisks ("*") in the unused
- space. You'll want to turn fillers on while printing the amount and
- amount string on the check (to make the check harder to modify). For
- example, "FillersOn" will cause the number "100.00" to print as
- "*****100.00" and "One Hundred & 00/100********". ALL text and
- variables are affected by "FillersOn". "FillersOff" (above) will turn
- the fillers off again.
-
- Example:
-
- FillersOn;
-
-
- 9.4.4.8 Input(<variable>,<prompt>,<response length>)
-
- The "Input" command requires three arguments:
-
- o A variable to assign the input to
-
- o A "prompt" message
-
- o The length of the input response
-
- When CheckMate Plus finds this command in the check layout, it will
- pause, display the "prompt message", and wait for you to enter the
- variable. You must have defined the variable with the "Variable"
- command before using it in an "Input" command. The variable can be
- any type, but it must be user-defined (as opposed to built-in).
-
- The "response length" is how much space CheckMate Plus will give you
- to enter the variable. The maximum length is 70 characters.
-
- Example:
-
- Input(Message,'Enter your message:',25);
-
-
- 9.4.4.9 NewCheck
-
- "NewCheck" takes no parameters. This command resets internal counters
- within CheckMate Plus. You should issue this command once at the end
- of the layout.
-
-
- Example:
-
-
-
- CheckMate Plus Introductory User's Guide 84
-
-
-
-
-
-
- NewCheck;
-
-
- 9.4.4.10 Page
-
- The "Page" command takes no arguments. The "Page" command sends a
- form feed to the printer. You can use this to eject single checks or
- when printing laser checks.
-
- Example:
-
- Page;
-
-
- 9.4.4.11 Pause
-
- The "Pause" command takes no arguments. When CheckMate Plus
- encounters this command, it will display a "pause message" and wait
- for the [SPACE BAR]. This is very useful for printing individual
- checks (the ones you tear out of your checkbook). You can have
- CheckMate Plus pause to adjust the check or lower the paper bail bar.
-
- Example:
-
- Pause;
-
-
- 9.4.4.12 PrinterString(<decimal number>,<decimal number>,...)
-
- "PrinterString" takes multiple arguments (from one to as many that
- will fit on the line). This command lets you send control codes to
- your printer (to change the font, line spacing, pitch, or anything
- else your printer supports). You may, for instance, want to place the
- printer in "italic mode" to print the payee's name.
-
- Enter each character to be sent to the printer as a decimal number
- representing the ASCII code for that character. (You'll find these
- codes in your printer's manual). Separate each code with a comma.
-
- Example:
-
- PrinterString(27,15,45);
-
- + NOTE: If you use the "PrinterString" command to change the pitch or
- width of the characters, CheckMate Plus can't accurately keep track of
- the current character "column". You may have to "experiment" to place
- text and variables exactly where you want. We suggest issuing a
- "column(1)" command to send the current character position back to
-
-
-
- CheckMate Plus Introductory User's Guide 85
-
-
-
-
-
-
- column 1. Some printers can't properly handle the carriage return,
- however (see the "Column" command above).
-
-
- 9.4.4.13 PrintTo(<destination>)
-
- The "PrintTo" command requires a single argument: where you want to
- send the check output. The "destination" you enter is a text string
- up to 66 characters long.
-
- If your printer is LPT1, then enter 'LPT1' as your destination. Other
- choices may be LPT2, COM1, COM2, etc. You can also enter a filename
- with a complete file path (although we don't know why you'd want to
- print checks to a file).
-
- If you don't use the "PrintTo" command in your layout, CheckMate Plus
- will default the output to LPT1.
-
- Example:
-
- PrintTo('LPT1');
-
-
- 9.4.4.14 SkipLines(<number of lines to skip>)
-
- "SkipLines" takes one argument: the number of lines you want to skip.
- CheckMate Plus issues a carriage return and line feed for each line,
- and sets the current column to 1.
-
- Example:
-
- SkipLines(5);
-
-
- 9.4.4.15 Stub(<left margin>,<chars/line>,<starting line>,<lines to
- print>)
-
- The "Stub" command takes four arguments:
-
- o The left margin (number of characters)
-
- o Characters per Line
-
- o Stub line to start printing
-
- o Total number of lines to print
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 86
-
-
-
-
-
-
- The "left margin" is the number of characters CheckMate Plus will skip
- before printing each line. "Characters per Line" is the number of
- characters CheckMate Plus will print after the left margin. "Stub
- line to start printing" is the first line of the stub CheckMate Plus
- will print (that is, it "skips" the lines above it). Total number of
- lines to print is the number of stub lines CheckMate Plus will print.
-
- + IMPORTANT: CheckMate Plus lets you print a custom stub or an
- "accounts payable" stub. (See "Stub Layout" in Chapter 4 for more
- information). Most of the above parameters refer to the custom stub.
- The "accounts payable" stub recognizes only the "left margin".
- "Characters per Line" defaults to 75; "Stub line to start printing"
- defaults to 1, and the "Total number of lines to print" defaults to
- 15. If you're going to mix custom and accounts payable stubs, it
- would be a good idea to set the "stub" parameters with these defaults
- so the custom stub will exactly match the accounts payable stub.
-
- Example:
-
- Stub(3,75,1,15);
-
-
- 9.4.4.16 Write(<variable or text>,<justification>,<field
- length>,<option>)
-
- The "Write" command prints a variable or text string at the current
- column on the current line. The "Write" command takes three or four
- arguments (depending on what you're writing):
-
- o Variable or Text
-
- o Justification
-
- o Field Length
-
- o Option (for variables only)
-
- The first argument is either a variable or text. If the argument
- starts (and ends) with a single quote (') then CheckMate Plus treats
- it as a text string rather than a variable. You can "write" all the
- built in variables as well as any you define yourself (see the
- "Variable" command).
-
- "Justification" is how you want the text or variable to print in its
- field. Enter a "L" for left-justified, "R" for right-justified, and
- "C" for centered. For instance, if you wanted to print the word
- "Test" in a field 8 characters long, here's how it would appear (the
-
-
-
-
- CheckMate Plus Introductory User's Guide 87
-
-
-
-
-
-
- "|" character denotes the start and end of the field. It doesn't
- print):
-
- Left-Justified: |Test |
- Right-Justified: | Test|
- Centered: | Test |
-
- "Field Length" is how many character spaces the text or variable can
- occupy.
-
- The "option" argument is valid only for variables. In most cases,
- you'll leave this field a zero ("0"). For any "numeric" variables
- (such as "amount" or user-defined reals and integers, the "option"
- represents the number of digits to display after the decimal point
- (usually two). See "Built-in Variables" for more information.
-
- Examples:
-
- Write(PayTo,L,35,0);
-
- Write('This is a test',C,40);
-
-
- 9.4.4.17 Writeln(<variable or text>,<justification>,<field
- length>,<option>)
-
- The "Writeln" command is identical to the "Write" command, except that
- a carriage return and linefeed are sent to the printer at the end of
- the command (and the current column is reset to 1).
-
- You can also issue a "Writeln" command with no arguments (which forces
- the printer to advance on line and sets the column counter to 1).
-
- Examples:
-
- Writeln(PayTo,L,35,0);
-
- Writeln('This is a test',C,40);
-
- Writeln;
-
-
- 9.4.4.18 Variable(<variable name>,<type>,<size>)
-
- This command lets you define your own variables (for printing,
- inputting data, or for use in expressions). The "Variable" command
- takes two or three arguments, depending on the variable type:
-
-
-
-
- CheckMate Plus Introductory User's Guide 88
-
-
-
-
-
-
- o Variable name
-
- o Variable type (string, real, or integer)
-
- o Variable size (string only)
-
- The variable "name" may be any combination of letters and numbers up
- to twenty characters long. You may also use any "printable"
- characters (including spaces) other than commas, semicolons, and the
- plus ("+") sign. Names are not case-sensitive. Each variable's name
- must be unique.
-
- You can define three types of variables: strings, reals, and integers.
- Strings are "text", reals are "floating point numbers", and integers
- are "whole numbers".
-
- "Variable size" is available only when you're defining a "string".
- Strings can be any length from 1 to 255 characters long. (Note,
- however, that CheckMate Plus will only print out to 132 columns).
-
- Examples:
-
- Variable(Total,real);
-
- Variable(Message,string,40);
-
- Variable(Number,integer);
-
-
-
- 9.4.5 Built-in Variables
-
- Here is a detailed list of the built-in variables you can print (and
- their associated "options" if any). Use the "options" with the
- "Write" and "Writeln" commands (see above).
-
- 9.4.5.1 Date
-
- The "Date" variable represents the transaction date. When you print
- the "date" (using "Write" or "Writeln"), you can affect the printing
- with the following "options" (see the "Write" command above):
-
- Options:
-
- o 0: displays the date as MMM DD, YYYY (i.e. Nov 25, 1990)
-
- o 1: displays the month and day as MMM DD (i.e. Nov 25)
-
-
-
-
- CheckMate Plus Introductory User's Guide 89
-
-
-
-
-
-
- o 2: displays the year as YYYY (i.e. 1990)
-
- o 3: displays the month as MMM (i.e. Nov)
-
- o 4: displays the day as DD (i.e. 25)
-
- o 5: displays the year as YY (i.e. 90)
-
- o 6: displays the month as MM (i.e. 11)
-
- o 7: displays the date as MM/DD/YY (i.e. 11/25/90)
-
- o 8: displays the date as MM/DD/YYYY (i.e. 11/25/1990)
-
- o 9: displays the month and day as MM/DD (i.e. 11/25)
-
- o 10: displays the date as DD/MM/YY (i.e. 25/11/90)
-
- o 11: displays the date as DD/MM/YYYY (i.e. 25/11/1990)
-
- o 12: displays the date as MMM DD, YYYY (i.e. Jan 25, 1990)
-
- o 13: displays the date (as you've set under "General Setups")
-
-
- 9.4.5.2 Check Number
-
- This variable holds the current "Check Number" (an integer).
-
- 9.4.5.3 PayTo
-
- The "PayTo" variable holds the name of the "payee" on the check. It
- is a string variable up to 35 characters long.
-
- 9.4.5.4 For
-
- The "For" variable holds the "For" field on the check. It is a string
- variable up to 25 characters long.
-
- 9.4.5.5 Vendor Acct#
-
- The "Vendor Acct#" variable holds the "Vendor Account Number" on the
- check. It is a string variable up to 30 characters long.
-
- 9.4.5.6 Comments
-
- The "Comments" variable holds the "Comments" on the check. It is a
- string variable up to 67 characters long.
-
-
-
- CheckMate Plus Introductory User's Guide 90
-
-
-
-
-
-
- 9.4.5.7 Amount
-
- The "Amount" variable holds the "amount" of the check. When you print
- the amount, the "option" field controls the number of digits displayed
- after the decimal point (usually 2).
-
- 9.4.5.8 Tax Ded
-
- The "Tax Ded" variable is YES or NO. It is a string variable up to 3
- characters long.
-
- 9.4.5.9 Marked
-
- The "Marked" variable is YES or NO. It is a string variable up to 3
- characters long.
-
- 9.4.5.10 Address 1
-
- "Address 1" is the first address line on the check. It is a string
- variable up to 35 characters long.
-
- 9.4.5.11 Address 2
-
- "Address 2" is the second address line on the check. It is a string
- variable up to 35 characters long.
-
- 9.4.5.12 Address 3
-
- "Address 3" is the third address line on the check. It is a string
- variable up to 35 characters long.
-
- 9.4.5.13 Amount String
-
- The "Amount String" is the "spelled out amount". It is a string
- variable up to 130 characters long.
-
-
- 9.4.6 Expressions
-
- CheckMate Plus' layout language also permits you to enter
- "expressions" and assign the results to a user-defined variable. You
- can then further manipulate or print the variable.
-
- Here is the expression syntax:
-
- <user defined variable>=<expression>;
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 91
-
-
-
-
-
-
- Notice that expressions also end with semicolons. The left side of
- the equation MUST be a user-defined variable (of any type).
-
-
- 9.4.6.1 Numeric Expressions
-
- If the variable on the left side of the equation is either an integer
- or a real, then the expression and all factors in it must be numeric.
- You can freely mix reals and integers in the expressions. The final
- result will be the same type as the variable you're assigning it to.
-
- You can use all standard operators (multiplication ("*"), division
- ("/"), addition ("+"), and subtraction ("-")) as well as parentheses
- to control the order of precedence. If you don't use parentheses, the
- order of precedence is: multiplication and division (in order of
- appearance), then addition and subtraction (in order of appearance).
- These are "standard" rules of precedence.
-
- Here's an example:
-
- variable(Number,real);
- Number=10+20/4;
-
- "Number" now holds the value "15". Here's a more complex example:
-
- variable(Number,real);
- variable(Total,real);
- Number=10+20/4;
- Total=(Number+3)*2;
-
- The variable "Number" now holds "15", while the variable "Total" holds
- "36". Remember you can include the built-in variables in the
- expression and you can use the "Input" (see above) command to assign
- values at print time.
-
-
- 9.4.6.2 String Expressions
-
- If the variable on the left side of the equation is a string, then
- all factors in the expression must be either string variables or text.
- String expression can use only on operator: concatenation ("+").
- Here's an example:
-
- variable(Message,string,30);
- Message='Hi there';
-
- The variable "Message" now holds the string "Hi there". Let's make
- the example a little more complex:
-
-
-
- CheckMate Plus Introductory User's Guide 92
-
-
-
-
-
-
- variable(Message,string,30);
- variable(Name,string,20);
- Message='Hi there';
- Name='John';
- Message=Message+'! My Name is '+Name+'.';
-
- Now the variable "Message" holds the string "Hi there! My Name is
- John."
-
- Remember you can use the "Input" command (see above) to assign text to
- variables at print time. You can also use "built-in" string variables
- in the expression. Can you see you can put together complex messages
- to print on the check?
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 93
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 94
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 10
-
- Graphics
-
-
- In addition to text reports, CheckMate Plus has a variety of graphic
- reports that can help you "visualize" your financial status.
-
-
- 10.1 System Requirements
-
-
- CheckMate Plus can display graphs on most PC graphics hardware. It
- supports CGA, EGA, VGA, and Hercules graphics. CheckMate Plus doesn't
- print graphs as of yet. If you need hard copies, use a "screen dump"
- utility (there are many available as commercial, shareware, and public
- domain utilities).
-
-
- 10.2 Graphic Reports
-
-
- The graphic reports in CheckMate Plus center around either a single or
- multiple accounts. When you first select "Graphics" from the
- "Reports" menu, CheckMate Plus will pop-up a menu asking which option
- you want: "One Account" or "Ledger".
-
- If you select "One Account", CheckMate Plus pops up yet another menu
- with two options: "Account Activity" or "Budget Analysis".
-
- Alternatively, selecting "Ledger" pops up a menu with these choices:
-
- Expenses vs Income
- Expenses by Month
- Income by Month
- Detailed Expense
- Detailed Income
- Debt to Equity
- Debt to Assets
-
- Let's examine each of the two menus one at a time.
-
-
-
-
- CheckMate Plus Introductory User's Guide 95
-
-
-
-
-
-
- 10.3 "One Account" Graphics Reports
-
-
- 10.3.1 Account Activity Graphics Report
-
- When you select this option, CheckMate Plus displays a window asking
- for a title, a starting month, and a "number of months" to display.
-
- This graph shows all "activity" (in the current control account only)
- over the range of months you specify. Press [F10] after you've
- entered your options and CheckMate Plus will pop up the "graph type"
- menu (in this case, you can display "3D" bar graphs, "plain" bar
- graphs, or line graphs). Make your choice and CheckMate Plus displays
- the graph.
-
- Press any key to exit the graph.
-
- 10.3.2 Budget Analysis Graphics Report
-
- After selecting this option, CheckMate Plus displays a window asking
- for a title, a starting month, and a "number of months" to display.
- This graph displays the "actual" activity of the control account next
- to the "budgeted" activity of the control account. Press [F10] after
- you've entered your options and CheckMate Plus will pop up the "graph
- type" menu (in this case, you can display "3D" bar graphs, "plain" bar
- graphs, or line graphs). Make your choice and CheckMate Plus displays
- the graph.
-
- Press any key to exit the graph.
-
-
- 10.4 "Ledger" Graphics Reports
-
-
- 10.4.1 Expenses vs Income Graphics Report
-
- This graph displays the total "revenue" next to the total "expenses"
- of each month you specify (for ALL accounts in your chart of
- accounts). Press [F10] after you've set your options. CheckMate Plus
- will pop up the "graph type" menu (in this case, you can display "3D"
- bar graphs, "plain" bar graphs, or line graphs). Make your choice and
- CheckMate Plus displays the graph.
-
- Press any key to exit the graph.
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 96
-
-
-
-
-
-
- 10.4.2 Expenses by Month Graphics Report
-
- This graph displays the total "expenses" for each month you specify
- (for ALL accounts in your chart of accounts). Press [F10] after
- you've set your options. CheckMate Plus will pop up the "graph type"
- menu (in this case, you can display "3D" bar graphs, "plain" bar
- graphs, or line graphs). Make your choice and CheckMate Plus displays
- the graph.
-
- Press any key to exit the graph.
-
- 10.4.3 Income by Month Graphics Report
-
- This graph displays the total "revenue" for each month you specify
- (for ALL accounts in your chart of accounts). Press [F10] after
- you've set your options. CheckMate Plus will pop up the "graph type"
- menu (in this case, you can display "3D" bar graphs, "plain" bar
- graphs, or line graphs). Make your choice and CheckMate Plus displays
- the graph.
-
- Press any key to exit the graph.
-
- 10.4.4 Detailed Expense Graphics Report
-
- This graph displays each expense account for the month you specify (up
- to 32). Press [F10] after you've set your options. CheckMate Plus
- will pop up the "graph type" menu (in this case, you can display "3D"
- bar graphs, "plain" bar graphs, or pie graphs). Make your choice and
- CheckMate Plus displays the graph.
-
- Press any key to exit the graph.
-
- 10.4.5 Detailed Income Graphics Report
-
- This graph displays each revenue account for the month you specify (up
- to 32). Press [F10] after you've set your options. CheckMate Plus
- will pop up the "graph type" menu (in this case, you can display "3D"
- bar graphs, "plain" bar graphs, or pie graphs). Make your choice and
- CheckMate Plus displays the graph.
-
- Press any key to exit the graph.
-
- 10.4.6 Debt to Equity Graphics Report
-
- This graph displays your total debt ("liabilities") next to your total
- "equity" for each month you specify (for ALL accounts in your chart of
- accounts). Press [F10] after you've set your options. CheckMate Plus
- will pop up the "graph type" menu (in this case, you can display "3D"
-
-
-
- CheckMate Plus Introductory User's Guide 97
-
-
-
-
-
-
- bar graphs, "plain" bar graphs, or line graphs). Make your choice and
- CheckMate Plus displays the graph.
-
- Press any key to exit the graph.
-
- 10.4.7 Debt to Assets Graphics Report
-
- This graph displays your total debt ("liabilities") next to your total
- "assets" for each month you specify (for ALL accounts in your chart of
- accounts). Press [F10] after you've set your options. CheckMate Plus
- will pop up the "graph type" menu (in this case, you can display "3D"
- bar graphs, "plain" bar graphs, or line graphs). Make your choice and
- CheckMate Plus displays the graph.
-
- Press any key to exit the graph.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 98
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 11
-
- Rebuilding and Repairing
-
-
- We've tried hard to make CheckMate Plus as reliable as possible.
- There are times, however, that you may need to "rebuild" or "repair"
- CheckMate Plus' data files. In this chapter we'll discuss each of the
- rebuild options (and the circumstances under which you may want to use
- them).
-
- One of the three options under the "rebuild menu" should fix 99% of
- the problems you may encounter. If you still have difficulties,
- contact Custom Technologies directly.
-
- When you select "Rebuild the Database" from the "Maintenance" menu,
- CheckMate Plus pops up the "rebuild menu" with these options:
-
- Complete Rebuild
- Rebuild Index Keys
- Rebuild Accounts
-
- Now let's look at each option.
-
-
- 11.1 Rebuilding the Database
-
-
- The "Complete Rebuilt" option is the most robust rebuild feature
- available. This function actually creates a whole new file by
- scanning the original file from start to finish. It then generates a
- completely new index file.
-
- CheckMate Plus does this by first creating an empty "working" file and
- writing "active" records to it one by one. You can specify where this
- "working" file will be. (If you have a RAM disk, specify it for the
- "working" disk to greatly speed things up). In any case, you must
- have sufficient free space in your "working" directory to completely
- copy the data file. Once the "working" file is complete, CheckMate
- Plus erases the original file and copies the "working" file back to
- the original drive and directory. After the original file has been
- replaced, CheckMate Plus proceeds to regenerate every index key.
-
-
-
- CheckMate Plus Introductory User's Guide 99
-
-
-
-
-
-
- + NOTE: This method of rebuilding, although somewhat slow, offers
- maximum safety in the event of an error, unexpected power loss, or
- lack of space.
-
- You'll want to use this procedure if you data file becomes corrupted
- for any reason. (DOS is a funny animal, and you never know what
- strange combination of events may cause you problems). This procedure
- also "compacts" the file (since it doesn't copy deleted records). If
- you've closed transactions or deleted a lot of records, this could
- significantly reduce the disk space you data file consumes.
-
- + NOTE: CheckMate Plus reuses deleted records before it expands its
- data file size, so you don't necessarily need to run this procedure
- after you delete or close transactions.
-
- After you've entered the "working" file path, press [F10] to begin the
- rebuild.
-
-
- 11.2 Rebuilding the Index File
-
-
- CheckMate Plus also lets you rebuild your "index" file at any time.
- This rebuild is less robust but much faster than the "complete
- rebuild" (and requires far less disk space).
-
- What CheckMate Plus does here is erase the index file and scan the
- data base, adding an index entry for each record. Use this procedure
- if transactions seem to appear more than once while editing, browsing,
- or printing reports. It may also find transactions that appear to be
- missing.
-
- Press [F10] to start the procedure.
-
-
- 11.3 Rebuilding Accounts
-
-
- The "Rebuild Accounts" option works on the account values (rather than
- the data file structure). This procedure computes the running
- balance, the last cleared transaction, and some other account specific
- values for all accounts in your data file.
-
- CheckMate Plus will automatically ask to run this routine any time it
- thinks it needs to, but you run it manually here. You'll usually need
- to run this procedure if you add, delete, or modify transactions out
- of date sequence.
-
-
-
-
- CheckMate Plus Introductory User's Guide 100
-
-
-
-
-
-
- Press [F10] to start the rebuild. Remember this procedure affects all
- accounts, not just the current control account.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 101
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 102
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 12
-
- Financial Calculations
-
-
- CheckMate Plus has some very useful routines for doing financial
- calculations. They're unrelated to CheckMate Plus' primary functions,
- but we think you'll appreciate their availability.
-
- When you select the "Finance" menu, you'll see three choices: Loans,
- Regular Deposits, and Compounding.
-
- The financial calculation windows are "calculation independent". That
- means that given all but one of the primary variables, CheckMate Plus
- can calculate the last one. While you're in the windows, leave one of
- the variables "zero" and fill in the rest. Press [F4] and CheckMate
- Plus will display the missing value!
-
- You may also press [F5] to "amortize" the calculation (and print an
- amortization report).
-
-
- 12.1 Loans
-
-
- Select "Loans" from the "Finance" menu to open the "Loan Calculation"
- window. Enter all but one of the of the "numbered" fields and press
- [F4] to calculate the last one.
-
- Press [F5] to open the "Loan Amortization Report Window". (You have
- the same formatting options here that you have for any report in
- CheckMate Plus. See "Report Printing Options", chapter, for more
- information).
-
- You can also specify the "payment range" you want to print. Press
- [F10] to start printing after you've setup your options.
-
- + NOTE: The "total Interest paid" value in the amortization report may
- differ slightly from the "Loan Calculations Window". This is because
- the amortization report can "adjust" the final payment slightly to
- exactly "pay off" the loan.
-
-
-
-
- CheckMate Plus Introductory User's Guide 103
-
-
-
-
-
-
- 12.2 Regular Deposits
-
-
- "Regular Deposits" are savings accounts, regular bond purchases, or
- any savings program where you deposit a set amount of money at set
- intervals. For instance, you may be contributing $100 per month for
- 30 years as a retirement plan.
-
- Select "Regular Deposits" from the "Finance" menu to open the "Regular
- Deposits" window. Just as in the "Loan" window, enter all but one of
- the of the "numbered" fields and press [F4] to calculate the last one.
-
- Press [F5] to open the "Deposit Amortization Report Window". (You
- have the same formatting options here that you have for any report in
- CheckMate Plus. See "Report Printing Options", chapter, for more
- information).
-
- You can also specify the "deposits range" you want to print. Press
- [F10] to start printing after you've setup your options.
-
-
- 12.3 Compounding a Fixed Sum
-
-
- "Compounding a fixed sum" means depositing a lump of money once and
- letting it "grow" over time.
-
- Select "Compounding" from the "Finance" menu to open the window. Just
- as in the "Loan" window, enter all but one of the of the "numbered"
- fields and press [F4] to calculate the last one.
-
- Press [F5] to open the "Compounding Amortization Report Window". (You
- have the same formatting options here that you have for any report in
- CheckMate Plus. See "Report Printing Options", chapter, for more
- information).
-
- You can also specify the "compounding ranges" you want to print.
- Press [ F10] to start printing after you've setup your options.
-
- + NOTE: Daily compounding (i.e. compounding 365 times per year) is
- fairly common, but will result in a huge report. Compounding daily
- for twenty years, for instance, generates 7,300 lines! In these
- cases, CheckMate Plus will selectively print "intervals" (say, every
- fifth line).
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 104
-
-
-
-
-
-
-
-
-
-
-
-
- Chapter 13
-
- Setup and Options
-
-
- In this chapter, we'll explore the many setups and options available
- to you for customizing CheckMate Plus.
-
- Select "Setup" from the main menu bar to pull-down the "Setup" menu.
-
-
- 13.1 Fiscal Year Information
-
-
- Pick "Fiscal Year" from the "Setup Menu" to open the "Fiscal Year
- Setup Window". Here you can set your current and past fiscal year(s).
-
- The first option you have is "Current Fiscal Year Start". You may
- start your "fiscal year" on the first day of any month and year. The
- month you enter here is important as CheckMate Plus uses this date
- while generating reports. You may change this date at any time
- without corrupting your data in any way, so you may change the date
- (and even go back to re-create past reports).
-
- One standard practice in accounting is to clear expense and revenue
- accounts at the end of each year (so you can start a new fiscal year
- with a clean slate). The balances of the expense and revenue accounts
- are transferred to an "equity" account, often called "Profit/Loss
- 1989", "Retained Earnings 1990", or the like. Once you choose to
- close a year, you can't go back and modify the numbers without making
- "reverse entries". You can do this with CheckMate Plus (see "Close
- Transactions" under the "Transactions" menu) or you can have CheckMate
- Plus "simulate" closing past years.
-
- The "Fiscal Year Setup Window" has space for 10 "past years". For
- each year you enter, CheckMate Plus lets you assign an "equity"
- account to clear all expenses and revenues to. IMPORTANT! CheckMate
- Plus only "simulates" clearing the values! This way, you can keep
- your transaction detail and the ability to modify past transactions
- for over ten years! The only time you'll see the balances transferred
- is when you print accounting reports (such as balance sheets and
-
-
-
-
- CheckMate Plus Introductory User's Guide 105
-
-
-
-
-
-
- income statements). You won't see them transferred when you look at
- account balances in the "enter" or "edit" features of CheckMate Plus.
-
- You enter "Past Years" as "years" only ("1989" for example). The
- starting and ending months depend upon the starting month of your
- "Current Fiscal Year Start". After you enter each year, you can
- specify the account you want to clear each year to. This must be an
- "equity account" (account numbers will range from 30000 to 39999).
- You must create these accounts before you can specify them here, and
- they must be detail accounts.
-
- + NOTE: You don't have to specify past years if you don't want to!
- CheckMate Plus will simply carry balances forward for any years not
- specified. What we've given you is maximum flexibility unparalleled
- in the industry.
-
- Also remember you can make the assignments permanent when you "Close
- Transactions" under the "Transactions" menu. When you do this, you'll
- no longer be able to view or edit those past transactions (since
- CheckMate Plus will erase them) but you will see the accumulated
- balances appear in the correct equity accounts.
-
- Press [F10] to save your "Current Fiscal Year Start" and all "past
- year" data.
-
-
- 13.2 Protecting Your "Audit Trail"
-
-
- Because CheckMate Plus allows you to retain many years worth of
- information, we included an "audit trail lock" which lets you assign a
- "password" to your audit trail. If you choose to activate the "audit
- lock", CheckMate Plus won't let you edit or delete any transactions or
- accounts entered before the current system date (unless you know the
- "audit lock" password). This password is completely separate from the
- system password (See "Password Setup" below).
-
- Select "Audit Lock" from the "Setup" menu to enter the "Audit Lock
- Setup Window". You have three options here.
-
- First, you have a YES/NO question asking you whether or not you want
- to lock data edit capability. The default is "NO".
-
- Next, you'll see the "Last Date Run". CheckMate Plus automatically
- updates this each time you run. You can't "fool" CheckMate Plus,
- however, because CheckMate Plus will never set this date "back" (so
- changing the DOS date won't help). We included the date here so you
- can manually set it back for a single session.
-
-
-
- CheckMate Plus Introductory User's Guide 106
-
-
-
-
-
-
- The last item you can enter is the "audit lock password". You'll have
- to enter this password each time you try to edit or delete a
- transaction or account that was entered before the "Last Date Run".
- Once you enter this password and turn the "audit lock" on (by
- answering "YES" to the above question), press [F10] to save the
- configuration.
-
- + IMPORTANT!: Once you've turned the "audit lock" on, you won't be
- able to get back into the "Audit Lock Setup Window" unless you know
- the "audit lock" password!
-
- If you forget your password, you'll need to send your data files to
- Custom Technologies and we will manually change it for you. We charge
- a nominal fee for this service. Call (719) 260-0402 for more
- information.
-
-
- 13.3 The Screen Saver
-
-
- When you select the "Screen Saver" option from the "Setup" menu, the
- "Screen-Save Setup" window will appear. In this window, you can
- enable or disable the screen saver feature. You can also indicate how
- long that you want CheckMate Plus to wait before it will blank the
- screen, and customize the message that CheckMate Plus displays while
- the screen saver is active. Remember that the screen will only go
- blank if no keyboard activity is detected for the indicated length of
- time.
-
- + NOTE: Delay times are approximate, and can vary based on CPU speed.
-
- You must press [F10] to save your setup to the disk.
-
- After the screen blanks, CheckMate Plus will display a slow-scrolling
- message indicating that the screen save feature is active. Press any
- character key to restore the screen to normal operation.
-
-
- 13.4 Colors
-
-
- If you have a color monitor, you can customize the screen colors in
- CheckMate Plus. Select "Colors" from the "Setup" menu to enter the
- "Color Setup Window".
-
- Notice that CheckMate Plus displays a "sample" window (so you can see
- what your color choices will look like). The cursor will be in the
- "window colors to customize" field. When you first enter the "color
-
-
-
- CheckMate Plus Introductory User's Guide 107
-
-
-
-
-
-
- setup window", the window colors to customize will be the "Main
- Colors". If you want to change, say, the MENU colors, press [alt-F10]
- to pop-up the "window select" menu. Pick "Menu Colors" (and the
- "sample window" will change to reflect the current menu colors).
-
- You can modify each window's foreground (bright characters), midground
- (dim characters), background color, and "reverse" color.
-
- For example, to modify a window's background color, press [F5] (and
- CheckMate Plus will "toggle" the color). Keep pressing [F5] until you
- find the color you want.
-
- Here are the color toggle keys:
-
- [F3] Toggle Foreground Color
-
- [F4] Toggle Midground Color
-
- [F5] Toggle Background Color
-
- [F6] Toggle "Reverse" Color
-
- Table 13.1: Color Toggle Keys
-
-
- Once you've setup all the colors (in all the windows that you want
- to), press [F10] to save your choices to disk. [ESC] returns you to
- the "Setup" menu.
-
-
- 13.5 Special Effects
-
-
- CheckMate Plus has a lot of "bells and whistles" which are fun to
- watch and pleasing to use. Some people, however, would prefer to
- modify or turn off their operation.
-
- You can modify the way CheckMate Plus opens and closes "windows" by
- choosing "Special Effects" from the "Setup" menu. The "Special
- Effects Setup" window will appear.
-
- If you don't want CheckMate Plus to give an audible 'opening window"
- click, then set the "do you want sound effects" field to "NO".
-
- If you want the windows to "explode" and "implode", then leave the "do
- you want exploding windows" field "YES". Otherwise mark it "NO".
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 108
-
-
-
-
-
-
- You can even set the speed for the exploding and imploding in the
- "speed for exploding windows". Set this field to "zero" for the
- fastest windows. Numbers 1 through 9 will gradually decrease the
- exploding speed. This field will have no effect if you have exploding
- windows turned off!
-
- Remember to press [F10] if you want to save your setups to disk.
-
-
- 13.6 Video Option
-
-
- CheckMate Plus can display some nice graphical reports (if you have a
- graphics display card in your computer). You tell CheckMate Plus the
- type of graphics you have when you install it (with the INSTALL
- command... see Chapter 1, "Introduction").
-
- The five options you have correspond to the following display types:
-
- CGA 640 x 200 dots, 1 color
-
- EGA 640 x 350 dots, 16 colors
-
- VGA 640 x 480 dots, 16 colors
-
- Hercules 720 x 350 dots, 1 color (monochrome)
-
- No Graphics (no graphics card installed)
-
- Table 13.2: Video Options
-
-
- You can't change your video option here. When you run INSTALL, the
- INSTALL program unpacks the correct "video driver" for your system.
- If you need to change your video option, rerun the INSTALL program
- (See Chapter 1). Press [ESC] to return to the "Setup" menu.
-
-
- 13.7 Password Setup
-
-
- For security, you may password protect each CheckMate Plus data file
- you create. Select "Passwords" from the "Setup" menu to reach the
- "Password Setup" window.
-
- Enter the "password" you want in the "Password" field. It can be up
- to eight characters long and is not case sensitive.
-
-
-
-
- CheckMate Plus Introductory User's Guide 109
-
-
-
-
-
-
- CheckMate Plus won't require a password unless you set the "Require
- Password at Program Start" to "YES" (and save your changes with
- [F10] ). Once you do this, CheckMate Plus will ask for your password
- before it will let you into the program.
-
- You'll also not be able to enter the "Password Setup Window" unless
- you know the password.
-
- + NOTE: CheckMate Plus associates the password with the data file, so
- reinstalling CheckMate Plus or erasing CMPLUS.OPT (the options file)
- WILL NOT defeat the security!
-
- If you forget your password, you'll need to send your data files to
- Custom Technologies and we will manually change your password for you.
- We charge a nominal fee for this service. Call (719) 260-0402 for
- more information.
-
-
- 13.8 File Paths
-
-
- Selecting "File Paths" from the "Setup" menu causes the "Data and
- Program Directories" window to appear. This window simply displays
- the currently active program and data file directories (you can't
- modify them here).
-
- The program file directory is the directory you were in when you
- started CheckMate Plus. You entered the data file directory on the
- command line when you started CheckMate Plus:
-
- cmplus <data file directory> <CR>
-
-
- 13.9 General Setups
-
-
- Select "General" from the "Setup" menu to pop-up the "General Setup
- Menu".
-
- Date Format You can pick from a variety of "date formats".
- CheckMate Plus will display all dates in this form.
- This is a "menu field", so you can press [alt-F10] or
- the middle button on the mouse to pop-up a menu of
- choices.
-
- You can enter free-format no matter which format you
- choose. CheckMate Plus will rearrange the date to
- match your format.
-
-
-
- CheckMate Plus Introductory User's Guide 110
-
-
-
-
-
-
- Separator Some of the date formats have "separators". For
- instance, 7/05/90 uses a "/" for a separator. You
- can change that separator here.
-
- + NOTE: If you choose the minus sign ("-") as a
- separator, you won't be able to use the minus sign to
- "decrement" the date while you're entering or
- editing.
-
- Currency Symbol You may set CheckMate Plus' currency symbol here.
- You must enter this symbol as an ASCII decimal value.
- The value for a dollar sign ($) is 36.
-
- Numeric Format Accountants tend to avoid using the minus sign to
- represent negative numbers. They prefer to enclose
- the number in parentheses. CheckMate Plus let's you
- choose how you want to display negatives. The
- parentheses appear only on the reports (and not while
- entering data).
-
- After you've set the options, press [F10] to make your changes
- permanent. [ESC] returns you to the "Setup" menu.
-
-
- 13.10 Report Defaults
-
-
- CheckMate Plus has many options for controlling the output and format
- of printed reports. You can set these options at print time, but you
- can also define default settings (so you don't have to change them
- every time you print a report).
-
- Select "Report Printing" from the "Setup" menu to pop-up the "Default
- Report Parameters Setup Window".
-
- Margins You can set the "margins" (top, bottom, left, and
- right). Express the top and bottom margins as a
- number of lines, and the left and right margins as a
- number of characters.
-
- + NOTE: CheckMate Plus assumes that you're using
- "fixed width" fonts for your reports (rather than
- proportionally spaced fonts). Most printers do use
- (or at least have the option to use) fixed width
- fonts.
-
- CheckMate Plus does not support "postscript" printers
- at this time.
-
-
-
- CheckMate Plus Introductory User's Guide 111
-
-
-
-
-
-
- Paper Sizes Paper size is a function of the number of lines per
- page you can print and the number of characters on
- each line. These numbers are absolute (i.e. they
- include margins).
-
- Most printers put 66 lines on a page. Many laser
- printers, however, require built-in top and bottom
- margins. The Hewlett Packard LaserJet, for example,
- can only print 60 lines per page.
-
- The number of characters per line you print will
- usually be determined by either the width of the
- paper (most paper is 8.5" wide) or by the "pitch" of
- the print. For instance, if your printer has a
- "compressed" mode (17 characters per inch), you can
- print 132 characters on a standard letter-sized sheet
- of paper.
-
- + NOTE: You can use the "Printer Setup Strings"
- (discussed below) to "command" your printer into
- compressed mode.
-
- Page Control You can tell CheckMate Plus to "pause" after each
- page to let you feed paper (if you're not using a
- laser printer or continuous feed paper).
-
- Printer Port CheckMate Plus lets you direct your printed reports
- to LPT1, LPT2, COM1, or COM2. Set your printer port
- in the "Printer Port for Reports" field. (This is a
- "menu field", so press [alt-F10] or the center mouse
- button to "pop" the menu up).
-
- Setup Strings CheckMate Plus lets you define printer "setup" and
- "exit" strings to control such things as margins,
- character pitch, attributes, etc. CheckMate Plus
- sends the "setup" strings to your printer before it
- starts the report and the "exit" strings after the
- report is completed.
-
-
- For instance, you may want to "command" your printer
- to print 17 characters per inch for some of the
- reports. You would enter the proper "control codes"
- in the "Printer Setup Strings" field.
-
- You'll probably want to use the "exit" strings to
- reset your printer (for normal operation).
-
-
-
-
- CheckMate Plus Introductory User's Guide 112
-
-
-
-
-
-
- The printer control codes can be found in your
- printer manual. The format for entry is
-
- \<decimal code>\<decimal code>\....
-
- The back-slashes delimit the codes. Here is an
- example:
-
- \27\85
-
- This string represents an <ESC> 'U'. (That's an
- escape-capital-U). This is a popular means of
- defining printer codes.
-
- To save you default options to disk, press [F10]. [ESC] returns you
- to the "Setup" menu.
-
-
- 13.11 Report Headings
-
-
- When you select "Report Headings" from the "Setup" menu, CheckMate
- Plus opens the "Report Heading Setup Window".
-
- You can enter up to ten lines of information (and CheckMate Plus will
- center each line as you go).
-
- CheckMate Plus prints these lines at the top of the first page of each
- report (except for blank lines at the bottom).
-
- Press [F10] to save your headings, and then [ESC] to return to the
- "Setup" menu. Press [ESC] without pressing [F10] to abort the changes
- you've made.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 113
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 114
-
-
-
-
-
-
-
-
-
-
-
-
- Appendix A
-
- An Accounting Primer
-
-
- This short tutorial is intended to give you a start into the world of
- classical accounting. It is by no means exhaustive, but it should get
- you going. If you run a small business, this primer will help, but
- you should still obtain a complete text or hire an accountant (or
- bookkeeper) to help you with some of the more difficult subjects.
- Since CheckMate Plus follows standard accounting rules, virtually any
- accounting text will be compatible. If you're a casual or home user,
- don't be frightened if this primer makes things seem complicated! For
- home use, the rules of accounting can be can be greatly relaxed.
-
-
- A.1 What is Accounting?
-
-
- Accounting is the term we apply to the discipline of maintaining
- complete and accurate financial data. Over the years, some well
- defined practices and conventions have developed. Adhering to these
- conventions will make your accounting data compatible with other
- people's data, and consequently it will be easier for others to
- understand. This is what we refer to as "classical" accounting.
-
- For business, proper accounting can spell the difference between
- success and failure. The fruits of the accounting system are the
- reports you can generate. These reports can help you analyze your
- cash flow and make decisions based on past and present performance.
- Having these reports available can you give you the competitive edge
- you need to succeed. Also, most banks, as well as the IRS, will want
- to see your balance sheet and income statements before doing business
- with you!
-
- To start, we must divide your holdings, debt, expenses and income. We
- will group these items under 5 categories: ASSETS, LIABILITIES,
- EQUITY, REVENUE, and EXPENSES.
-
- A.1.1 What are ASSETS?
-
- Assets are money, land, items, etc that you have in your possession.
-
-
-
- CheckMate Plus Introductory User's Guide 115
-
-
-
-
-
-
- Essentially, they are anything that holds any value. You do not have
- to own something for it to be an asset. For instance, the bank may
- hold the deed to your home while you pay off the note. But since the
- use of the home is under your control, it is still an asset to you.
- We will see below how we can balance this asset with a corresponding
- debt (or liability). Assets can take many forms. If someone owes you
- money, for instance, then you have an asset in the form of a note or
- an IOU.
-
- A.1.2 What are LIABILITIES?
-
- Liabilities are any debts you owe. In the example above, we have an
- asset (our home). But we also owe money against the home, and that is
- a liability. Not all liabilities need be bank loans. In a business,
- money we owe to our employees (in the form of pay) is a liability.
- Income tax we owe the government is also a liability, as is rent due,
- etc. In short, any time we owe money or services we have a liability.
-
- A.1.3 What is EQUITY?
-
- Equity is the difference between our assets and our liabilities. The
- equity in your home, for example, is the difference between the value
- of your home (your asset) and the money you owe (your liability).
- Your total net worth, then, is the delta between all of your assets
- and the total of your liabilities.
-
- A.1.4 The Accounting Equation
-
- It is the above relationship that forms the principle behind classical
- accounting. We can state that relationship as such:
-
- ASSETS - LIABILITIES = EQUITY
-
- If we do a little math, we can rearrange the above equation:
-
- ASSETS = LIABILITIES + EQUITY
-
- This equation is referred to as the ACCOUNTING EQUATION. Remember
- it... it is important!
-
- The principle of this equation is clear. If you increase your assets,
- then something else has to change to keep the equation true. Let's
- say you buy a car, and hence increase your assets (you now have a
- car). To keep the above equation true, you must do one of three
- things:
-
- 1) Decrease another asset (pay cash or trade for the car)
- 2) Increase a liability (borrow the money for the car)
-
-
-
- CheckMate Plus Introductory User's Guide 116
-
-
-
-
-
-
- 3) Increase your equity
-
- The first two options are straightforward and are easily understood.
- The last option is a little more difficult to understand until we
- further explore how we can make changes to equity.
-
- A.1.5 What are REVENUE and EXPENSES?
-
- The three categories we discussed above describe your financial status
- in a "static" way. There is no way to either increase nor decrease
- your net worth (equity) by merely adding assets or liabilities.
- Revenue and expenses provide this avenue.
-
- Revenue is money you take in, usually in exchange for goods or
- services. Revenue has the characteristic of INCREASING your equity.
- That is, an asset will increase (such as cash) with NO corresponding
- increase in a liability. Not all money you take in is revenue. Money
- you receive in payment of a debt, for example, increases an asset
- (cash) but also decreases another asset (the note you hold). The net
- effect is that your equity is unchanged. In the above example, you
- could obtain the new car by working for it, or maybe by winning it in
- a contest. In either case, we have increased our equity by the same
- amount we have increased our assets (the price of the car).
-
- Expenses reduce your equity. A good example is your power bill. You
- pay the bill with cash, and your assets are reduced. But you did not
- reduce a liability, and you did not increase another asset. The
- electricity was consumed! Whether or not goods or services are
- "consumed" is one good way to tell expenses apart from liabilities.
-
- In the case of a business or a corporation, you can increase
- or decrease the company's equity in another fashion. When you sell
- stock, you DIRECTLY increase the equity in the company. But it is not
- YOUR equity in the company that has increased, but the person who
- bought the stock. In fact, a company can have many, many owners.
- That is why we will often refer to equity as OWNER'S EQUITY.
-
- But lets' get back to revenue and expenses. There is yet another
- relationship we should document here. This one is more familiar:
-
- PROFIT (or LOSS) = REVENUE - EXPENSES
-
- Notice if expenses exceed revenue, we have incurred a LOSS. Let me
- take a minute to point out that (LOSS) here is in parentheses.
- Accountants typically do not like to use negative numbers, but rather
- indicate a negative amount by enclosing it in parentheses. In
- CheckMate Plus, we give you the option of using either convention. In
- either case, the difference between revenue and expenses will tend to
-
-
-
- CheckMate Plus Introductory User's Guide 117
-
-
-
-
-
-
- either increase or decrease our equity. Also notice if equity
- changes, then either assets or liabilities must change. Let's say we
- incur a loss, and equity decreases. To make the accounting equation
- remain true, we must either draw on assets (maybe take cash to pay the
- loss) or increase liabilities (perhaps borrow money to make up for the
- loss).
-
- Revenue and expenses are actually only extensions of equity. We give
- them their own categories since it is useful to treat them separately
- while computing profit or loss.
-
-
- A.2 How does it all work in real life?
-
-
- To try and tie the above principles together, let's hypothesize a
- small company, called XYZ Shoes, Inc. We will draw on this example
- throughout the remainder of this primer.
-
-
- A.2.1 What are ACCOUNTS?
-
- Accounts are the accountant's method of separating and detailing
- individual items under each of the above categories. You can think of
- an account as the dollar value of each item. We will give each
- account a descriptive name, as well as an account number.
-
- Accounts are logical entities, and it may be difficult to physically
- separate them from one another. This is OK, because we don't need
- to... we merely need to track the current value of each account.
-
- Things may be starting to seem confusing. An example here is in
- order. Consider our ASSETS category. We will use accounts to break
- down and detail the assets of the XYZ Shoe company:
-
- Cash: 1,485.11
- Checking Account: 1,642.69
- Building: 101,987.88
- Inventory: 9,251.11
- Pickup Truck: 13,000.00
- Office Furniture: 4,400.00
- Office Equipment: 7,550.85
- Accounts Receivable: 2,264.76
-
- Table A.1: Assets of XYZ Shoes, Inc as of Mar 1, 1987
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 118
-
-
-
-
-
-
- Each item we listed has become an account. The total of all the
- listed accounts will be the total assets for XYZ. Now let's list the
- liabilities and equity accounts:
-
- Accounts Payable: 1,345.00
- Salaries Payable: 3,150.00
- Sales Tax Payable: 437.25
- Income Tax Payable: 0.00
- Mortgage: 84,055.80
-
- Table A.2: Liabilities of XYZ Shoes, Inc as of Mar 1, 1987
-
-
- Initial Capital: 54,430.53
- Profit/Loss: 0.00
-
- Table A.3: Equity of XYZ Shoes, Inc as of Mar 1, 1987
-
-
- We are assuming (for the purpose of this example) that the above data
- was true on Jan 1, 1987. Profit/Loss is zero, since we have incurred
- no expenses nor made any revenue in the new year. We will follow
- the example and see how the profit builds.
-
- If you total the amounts above, you'll see the accounting equation is
- satisfied. But don't bother just yet... we will prove it in a minute.
-
- Now lets construct our "Chart of Accounts", which is simply a listing
- of all our accounts. We will also add our REVENUE and EXPENSE
- accounts while we are at it.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 119
-
-
-
-
-
-
- ------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ------------------------------------------------------------------
- Chart of Accounts Report Mar 1, 1987
- ------------------------------------------------------------------
-
-
- 1 ASSETS
- 10000 Cash DB
- 10001 Checking Account DB
- 10002 Building DB
- 10003 Inventory DB
- 10004 Pickup Truck DB
- 10005 Office Furniture DB
- 10006 Office Equipment DB
- 10007 Accounts Receivable DB
- 10008 Purchases DB
-
-
- 2 LIABILITIES
- 20000 Accounts Payable CR
- 20001 Salaries Payable CR
- 20002 Sales Tax Payable CR
- 20003 Income Tax Payable CR
- 20004 Mortgage CR
-
-
- 3 EQUITY
- 30000 Initial Capital CR
- 30001 Profit/Loss CR
- 39999 Non-Accounted For Funds CR
-
-
- 4 REVENUE
- 40000 Sales CR
- 40001 Misc Income CR
-
-
- 5 EXPENSES
- 50000 Cost of Goods Sold DB
- 50001 Salary Expense DB
- 50002 Utilities Expense DB
- 50003 Interest Expense DB
-
-
-
- CheckMate Plus Introductory User's Guide 120
-
-
-
-
-
-
- 50004 Misc Expense DB
-
-
- XYZ Shoes, Inc. Page 1
-
- Figure A.1: Chart of Accounts for XYZ Shoes, Inc.
-
- We used CheckMate Plus to print the chart. See the account numbers?
- The five major categories are numbered '1' through '5', and each
- account under them begins with the same number. This is a common and
- logical way to number and group your accounts. The 'DB' and 'CR'
- stand for 'debit' and 'credit'... we are just about to get around to
- that...
-
- A.2.2 What are DEBITS and CREDITS?
-
- It makes sense when you use cash to pay a loan, you decrease an asset
- (cash) and decrease a liability (the loan). It is easy to visualize,
- but not so easy to document. Accountants use a system of 'debits' and
- 'credits' to document the flow of value. Also, remember accountants
- avoid the use of negatives wherever possible.
-
- Every account has a balance. We saw that the sum of the asset
- accounts must equal the sum of the liability and equity accounts. We
- will say, arbitrarily, that assets have DEBIT balances and both
- liabilities and equity have CREDIT balances. Therefore, the total
- debit balance equals the total credit balance.
-
- Whoa! You may well be wondering how we decided to assign "types" to
- the balances. It is strictly a way of looking at the data. If we say
- assets have debit balances and both liabilities and equity have credit
- balances, we have merely transformed the accounting equation into this
- form:
-
- DEBITS = CREDITS
-
- Take a minute and let this sink in. The concept is the same... we
- have just changed the notation. When you understand the difference
- between a debit and a credit, you'll be over a major hurdle in
- understanding the basic premises of accounting.
-
- Now lets transform this notation into practice. An asset carries a
- debit balance. This means that when we wish to INCREASE the asset we
- must DEBIT the account. So, if I start with $50 in an account, and I
- make a $100 debit, I now have $150 in the account.
-
- Most people unfamiliar with accounting may scratch their head at this
- point. Does it seem backwards? After all, when the bank DEBITs my
-
-
-
- CheckMate Plus Introductory User's Guide 121
-
-
-
-
-
-
- account, my assets DECREASE, not increase. True, BUT the debit is
- from the bank's point of view, not yours! The debit did increase the
- bank's assets (at your expense!). That is why we refer to the
- transaction types as BANK DEBITS and BANK CREDITS (in checking
- accounts), so there is no confusion on whose point of view is
- prevailing.
-
- Conversely, we will credit a liability or equity account to increase
- it. Can you see that when we want to DECREASE a liability we will
- debit it? Let's look at the payment of a loan again. We have two
- accounts... one called 'CASH' and one called 'LOAN'. CASH is an
- asset (debit) account and LOAN is a liability (credit) account. When
- we make payments on a loan, both accounts must decrease (cash is
- obviously less, and now we owe less). Let's see it work:
-
- Pay $50.00 cash (credit CASH $50)
- Lower loan $50.00 (debit LOAN $50)
-
-
- See what we have done? We have credited CASH and debited LOAN, and
- the sum of the debits ($50.00) equals the sum of the credits ($50.00).
- It may still not be crystal clear, but give it a little time. What we
- have documented above is a TRANSACTION. The transaction affects the
- balances of our accounts. As always, we MUST make sure the accounting
- equation is satisfied. To do this, the transaction must not disturb
- the overall balance of the equation. Hence, all debit entries in a
- transaction must equal all credit entries in the transaction!
-
- Incidentally, here is how CheckMate Plus would document the
- transaction. Notice that the sum of debits and credits do indeed
- equal.
-
- ----------------------------------------------------------------------
- Date: Jul 1, 1990
- Acct# Account Name Description Debit Credit
- ----- ---------------- ----------------- ------------ ------------
- 10000 Cash Payment to LOAN 50.00
- 20005 LOAN Reduce LOAN 50.00
- ------------ ------------
- 50.00 50.00
- ----------------------------------------------------------------------
-
- Figure A.2: Sample Transaction
-
- The above transaction is a "double-entry" transaction since we made
- two entries (to show how the money flowed from one account to
- another). Now you can see why people call true accounting systems
- "double-entry" systems. In real life, however, money often flows
-
-
-
- CheckMate Plus Introductory User's Guide 122
-
-
-
-
-
-
- to and from many accounts in the same transaction. CheckMate Plus
- will let you make up to twelve entries per transaction.
-
- Let's see how this would work. Assume Mr. Jackson walks into XYZ's
- showroom and wants to buy a pair of alligator skin boots with inlaid
- gold and ruby trim. The price on the shoes (on sale) is $999.95. Mr.
- Jackson has good credit, and decides to pay $200 cash and make the
- rest in weekly installments of $50. How would this transaction be
- recorded?
-
- ----------------------------------------------------------------------
- Date: Mar 22, 1987
- Acct# Account Name Description Debit Credit
- ----- ----------------- ---------------- ------------ ------------
- 10007 Accounts Receivab On Credit 849.95
- 20002 Sales Tax Payable 5% Sales Tax 50.00
- 40000 Sales Mr. Jackson 999.95
- 10000 Cash Down Payment 200.00
- ------------ ------------
- 1,049.95 1,049.95
- ----------------------------------------------------------------------
-
- Figure A.3: Sample Sales Transaction
-
- In a single transaction, we have made four entries. We have increased
- (debited) two assets, CASH and ACCOUNTS RECEIVABLE. We have also
- increased (credited) a liability (SALES TAX PAYABLE) and a revenue
- (SALES). Mr. Jackson has paid $200 and still owes $849.95 for a total
- of $1049.95 (including sales tax).
-
- You should take a moment to see how future transactions will develop.
- Every time Mr. Jackson makes a payment on his boots, we will debit
- (increase) CASH and credit (decrease) ACCOUNTS RECEIVABLE. Also, when
- we pay the state our sales tax due, we will credit (decrease) CASH and
- debit (decrease) SALES TAX PAYABLE. For you folks in business...
- notice how the sales tax never found its way into either revenue or
- expenses? It shouldn't, since the collection and paying of sales tax
- does not affect our profit or loss!
-
- Speaking of profit and loss... how much profit did we make when we
- sold the boots? Well, the cost of the boots falls into the account
- COST OF GOODS SOLD. But rather than calculate profit on every sale,
- XYZ uses the End-of-Period Adjustment method. At the end of each
- month, XYZ will take an inventory of all shoes in stock. The
- difference between the current (closing) inventory and last month's
- (opening) inventory is entered into the journal. As we make purchases
- during the month, we enter them into an account called PURCHASES.
- Since the change in inventory will include these purchases at month's
-
-
-
- CheckMate Plus Introductory User's Guide 123
-
-
-
-
-
-
- end, we must also "clear" our PURCHASES while we calculate the COST OF
- GOODS SOLD.
-
- The difference between the two is COST OF GOODS SOLD for the month.
- To illustrate, suppose XYZ had $9,251.11 worth of shoes at the end of
- February. At the end of March they had $9,145.00 worth of shoes in
- stock. During March, they bought $1,628.02 worth of new shoes. What
- is the COST OF GOODS SOLD during March?
-
- First, calculate the change in Inventory during the month of March.
- You do this by subtracting the balance of Inventory at the end of
- February from the balance of Inventory at the end of March:
-
- Inventory at end of February: 9,251.11
- Inventory at end of March: 9,145.00
- --------
- Change in Inventory 106.11
-
- Now, record the transaction as follows:
-
- ----------------------------------------------------------------------
- Date: Mar 31, 1987
- Acct# Account Name Description Debit Credit
- ----- ----------------- ---------------- ------------ ------------
- 10003 Inventory Change in Inventory 106.11
- 10008 Purchases Clear Purchases 1,628.02
- 50000 Cost of Goods Sold For March 1987 1,734.13
- ------------ ------------
- 1,734.13 1,734.13
- ----------------------------------------------------------------------
-
- Figure A.4: Sample COGS Calculation
-
- The COGS (Cost of Goods Sold) for March was $1,734.13. I realize this
- is kind of a whirlwind approach to accounting methods. Remember, this
- is a simple primer designed to get you started off. There have been
- entire volumes written on accounting, and we can't hope to cover all
- the subjects here. If you need to do serious business accounting, we
- heartily recommend that you get yourself a good book or an accountant
- to help you!
-
- Hopefully you now can visualize this subject of debits and credits.
- We also hope you have a grasp on the concepts of profit and loss. We
- will now pursue that topic in more detail.
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 124
-
-
-
-
-
-
- A.3 Accounting Reports
-
-
- At the end of each accounting period (usually a month or quarter),
- you'll generate a series of accounting reports. There are two general
- types of reports (ledger and summary).
-
- Ledger reports are very detailed. These are your ACTIVITY REPORT and
- your TRANSACTION REPORT.
-
- In short, the activity report lists all accounts sequentially and the
- debit and credit summary of each. If you make end-of-month
- adjustments (like the one discussed above for COST OF GOODS SOLD),
- this report will help you collect the figures you need. The other
- report, your TRANSACTION REPORT, details all entries for the month and
- serves as your permanent record that these entries were made.
-
- In a "manual" accounting system, you have to POST the each period's
- transactions before you can generate the "summary" reports. This
- involves transferring all debits and credits for each transaction to
- the corresponding accounts in the ledger. This can be tedious and
- long! Thank goodness the computer (and CheckMate Plus) will do it for
- us. CheckMate Plus actually posts "on the fly" as you create your
- summary reports. (This is a very powerful feature, as it let's you
- "backup" if you need to!).
-
- Now let's discuss the "summary reports" (which are the Balance Sheet
- and the Income Statement). These are the real fruits of all your
- effort in maintaining an accounting system!
-
- A.3.1 The Trial Balance
-
- In "manual" accounting systems, accountants generate a "trial balance"
- before they actually "post". Since CheckMate Plus let's you post "on
- the fly", you can generate this trial balance at any time!
-
- All a trial balance is is a list of detail accounts and their
- corresponding debit or credit balance. If everything's OK, the total
- of credits should equal the total of debits. Accountants use the
- trial balance to make sure no "balancing" mistakes were made while
- entering transactions.
-
- If the trial balance fails (i.e. debits<>credits), you've must find
- and fix the error before creating a final Balance Sheet and Income
- Statement.
-
- + NOTE: CheckMate Plus "forces" your books to balance by automatically
- "balancing" transactions that are not "balanced". It assigns excess
-
-
-
- CheckMate Plus Introductory User's Guide 125
-
-
-
-
-
-
- funds to a special account (Non-Accounted for Funds). CheckMate Plus
- will omit this account in the Trial Balance, however, so you can track
- down mistakes.
-
- Here's a sample Trial Balance for XYZ Shoes:
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 126
-
-
-
-
-
-
- ----------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ----------------------------------------------------------------------
- Trial Balance Mar 31, 1987
- ----------------------------------------------------------------------
-
- Account Debit Credit
- -------------------------------- ------------- -------------
- 10000 Cash 1,685.11
- 10001 Checking Account 1,642.69
- 10002 Building 101,987.88
- 10003 Inventory 9,145.00
- 10004 Pickup Truck 13,000.00
- 10005 Office Furniture 4,400.00
- 10006 Office Equipment 7,550.85
- 10007 Accounts Receivable 3,114.71
- 10008 Purchases 1,471.98
-
- 20000 Accounts Payable 1,345.00
- 20001 Salaries Payable 3,150.00
- 20002 Sales Tax Payable 487.25
- 20003 Income Tax Payable
- 20004 Mortgage 84,055.80
-
- 30000 Initial Capital 54,430.43
- 30001 Profit/Loss
-
- 40000 Sales 12,488.79
- 40001 Misc Income 320.00
-
- 50000 Cost of Goods Sold 10,537.13
- 50001 Salary Expense 1,200.00
- 50002 Utilities Expense 125.33
- 50003 Interest Expense 128.59
- 50004 Misc Expense 288.00
- ------------- -------------
- 156,277.27 156,277.27
- ============= =============
-
- XYZ Shoes, Inc. Page 1
-
- Figure A.5: Trial Balance for XYZ Shoes, Inc
-
-
-
-
- CheckMate Plus Introductory User's Guide 127
-
-
-
-
-
-
- A.3.2 The Balance Sheet
-
- Remember the accounting equation? The way we prove we have followed
- all the rules is through our BALANCE SHEET. The balance sheet can be
- very detailed or very general. CheckMate Plus will generate a balance
- sheet that will list ALL of your asset accounts and show how they
- balance against ALL of your liability and equity accounts. This is a
- very detailed balance sheet. If we summarized the data (which you can
- do by customizing your reports), you could produce a general balance
- sheet. The balance sheet is a snapshot of the company's holdings and
- debt at a given instant. It does not reflect the passage of any time,
- but rather shows an entity's current worth.
-
- An example is worth a thousand words. Below is an example for
- XYZ Shoes. Notice the total of assets does indeed equal the total of
- liabilities and equity.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 128
-
-
-
-
-
-
- ----------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ----------------------------------------------------------------------
- Balance Sheet Mar 31, 1987
- ----------------------------------------------------------------------
-
- BALANCE SHEET
- (as of Mar 31, 1987)
-
-
- * ASSETS
-
- 10000 Cash 1,685.11
- 10001 Checking Account 1,642.69
- 10002 Building 101,987.88
- 10003 Inventory 9,145.00
- 10004 Pickup Truck 13,000.00
- 10005 Office Furniture 4,400.00
- 10006 Office Equipment 7,550.85
- 10007 Accounts Receivable 3,114.71
- 10008 Purchases 1,471.98
- --------------
- Total Assets 143,998.22
- ==============
-
- * LIABILITIES AND EQUITY
-
- Liabilities
- 20000 Accounts Payable 1,345.00
- 20001 Salaries Payable 3,150.00
- 20002 Sales Tax Payable 487.25
- 20003 Income Tax Payable 0.00
- 20004 Mortgage 84,055.80
- --------------
- Total Liabilities 89,038.05
-
- Equity
- 30000 Initial Capital 54,430.43
- 30001 Profit/Loss 0.00
- 39999 Non-Accounted For Funds 0.00
- plus REVENUE 12,808.79
- less EXPENSES 12,279.05
- --------------
-
-
-
- CheckMate Plus Introductory User's Guide 129
-
-
-
-
-
-
- Total Equity 54,960.17
- --------------
- Total Liabilities + Equity 143,998.22
- ==============
-
-
- XYZ Shoes, Inc. Page 1
-
- Figure A.6: Balance Sheet for XYZ Shoes, Inc.
-
- A.3.3 The Income Statement
-
- The Income Statement, on the other hand, does reflect a change from
- earlier period to the present. It is simply the difference between
- REVENUE and EXPENSES for a given period. You can create monthly,
- quarterly, and yearly reports, and, like the balance sheets they may
- be very general or very specific. CheckMate Plus will let you
- automatically create very detailed monthly, quarterly, or yearly
- income statements. An example (for XYZ shoes) is presented below.
- The data is all hypothetical.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 130
-
-
-
-
-
-
- ----------------------------------------------------------------------
- XYZ Shoes, Inc
- PO Box 0000
- Anytown, USA
- (555) 555-5555
-
- "Our Shoes Smell Good"
- ----------------------------------------------------------------------
- Income Statement Mar 31, 1987
- ----------------------------------------------------------------------
-
- INCOME STATEMENT
- (Mar 1, 1987 to Mar 31, 1987)
-
-
- * REVENUE
-
- 40000 Sales 12,488.79
- 40001 Misc Income 320.00
- --------------
- Total Revenue 12,808.79
-
- * EXPENSES
-
- 50000 Cost of Goods Sold 10,537.13
- 50001 Salary Expense 1,200.00
- 50002 Utilities Expense 125.33
- 50003 Interest Expense 128.59
- 50004 Misc Expense 288.00
- --------------
- Total Expenses 12,279.05
- --------------
-
- Total Profit (Loss) 529.74
- ==============
-
-
- XYZ Shoes, Inc. Page 1
-
- Figure A.7: Income Statement for XYZ Shoes, Inc.
-
- These reports are produced at the end of an accounting PERIOD, usually
- a month, and are called End-of-Period Reports. You'll also want to
- create end-of-year reports, which are essentially reports created
- after your last month and BEFORE you do your end-of-year maintenance
- (discussed below).
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 131
-
-
-
-
-
-
- These reports offer a wealth of information. As you produce reports
- each month, you can draw additional information by comparing new
- reports with old. These reports will also be helpful while
- filing taxes (or surviving an audit) and when negotiating with the
- bank for loans.
-
- Home users have the opportunity to see trends in their spending and to
- quantify their net worth. Few individuals or families REALLY know
- where they are financially. CheckMate Plus can help you make your
- dollars go farther by showing you where they went in the past!
-
-
- A.4 Where does it all end?
-
-
- We aren't quite finished yet. There is still one more topic to
- cover... ending the accounting year. At some point we want to
- consolidate cumulative data and "reset" our books. This is the end-
- of-year routine.
-
- We do NOT zero out our current balances at the end of a year. Rather,
- at the start of any year, our current balance for each account should
- equal the last year's balance for that account. This makes sense,
- when you think about it, but there is an exception.
-
- Remember REVENUE and EXPENSES are actually subsets of EQUITY? We keep
- them separate during the year so we can quickly assess our profit/loss
- picture. At the end of the year, however, we want to zero the revenue
- and expense accounts and start with a clean slate.
-
- Anytime we change an account's balance we must make a corresponding
- change to another account (remember the accounting equation!). In
- order to "zero" our revenue and expenses, then, we must make balancing
- entries to some other appropriate account. This balancing account is
- usually called "Profit and Loss" or "Retained Earnings." Since the
- profit (or loss) for the year is the difference between revenue and
- expenses, these names are both appropriate. For this discussion, lets
- call the account PROFIT/LOSS. This account, by the way, is an EQUITY
- account.
-
- So what do we do? Well, we simply transfer the balance of each
- revenue account to PROFIT/LOSS. Since revenue accounts are CREDIT
- accounts, we do this by DEBITING each revenue account and CREDITING
- PROFIT/LOSS. So debits and credits are equal, and all revenue
- accounts now have a current balance of zero.
-
- Now repeat the process with all expense accounts. Our debits and
- credits are reversed now, however, since expenses are DEBIT accounts.
-
-
-
- CheckMate Plus Introductory User's Guide 132
-
-
-
-
-
-
- Can you see PROFIT/LOSS now holds the DIFFERENCE between revenues and
- expenses?
-
- CheckMate Plus automates the end-of-year routines as well. When you
- start a new accounting year, all you have to do is change the "Fiscal
- Year Start" and CheckMate Plus knows to treat EXPENSES and REVENUE as
- "clean" on that date. You can assign all previous profits (or losses)
- to a specific account under equity (for the balance sheet). Now we
- are ready for a new year and can track our profit and loss situation
- independently of previous years' data!
-
-
- A.5 Final Thoughts
-
-
- I certainly hope this primer has been of some use. It is not meant to
- be a substitute for formal education, since it is much to brief to
- cover many of the aspects of accounting you'll encounter as you run
- your home or business. It should give you a push, however, and
- perhaps make talking to your bookkeeper a little easier.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 133
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 134
-
-
-
-
-
-
-
-
-
-
-
-
- Appendix B
-
- Ordering Checks
-
-
- CheckMate Plus automatically supports checks from NEBS Computer Forms.
- When you register, you'll receive a package containing ordering
- information along with the printed User's Guide.
-
- CheckMate Plus supports the following NEBS formats automatically:
-
- NEBS 9025 (multipurpose check with stub)
- NEBS 9029 (multipurpose check without stub)
- NEBS 9027 (laser check with stub)
-
- If you want to contact NEBS directly, call NEBS at
-
- 1-800-388-3810
-
- *IMPORTANT!* You must give them this mail code number:
-
- 95024
-
- They can send you information or take your order over the phone.
-
- We can also send you a sample package with complete ordering
- information. If you'd like to order checks before you register, call
- Custom Technologies at (719) 260-0402 and ask for the NEBS sample
- package. We'll gladly send it to you without any pressure to register
- (we want you to be completely satisfied with CheckMate Plus before you
- pay for it).
-
- BONUS! We've made a special arrangement with NEBS Computer Forms.
- When you register (or when you call us directly for check ordering
- information), we'll include a special coupon for 250 FREE "DU-O-VUE"
- window envelopes compatible with NEBS checks. That's an $18.50 value!
- You must include the coupon with your first order, so contact us
- before ordering (to take advantage of this special offer). This offer
- is subject to end without notice.
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 135
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 136
-
-
-
-
-
-
-
-
-
-
-
-
- Appendix C
-
- How and Where to get Help
-
-
- C.1 Technical Support
-
-
- Technical support by telephone, mail, or FAX is ordinarily reserved
- for registered users. We'll help you ONE TIME before you register to
- help install CheckMate Plus for evaluation or to answer general
- questions.
-
- If you have questions or require technical support, call our technical
- support line at (719) 260-0402. Do not call our toll-free order
- number with questions, as the operators there can't help you (they are
- completely unfamiliar with the program's operation). Our FAX number
- is (719) 260-0543.
-
- You may write us a letter if you wish, but we are often swamped with
- letters and it may be some time before you receive a reply.
-
- Custom Technologies
- PO Box 62118
- Colorado Springs, CO 80962-2118
-
- You can also reach us for technical support on CompuServe. We are
- topic 7 in the PC Vendor A Support Forum. Just type "GO PCVENA" at
- any CompuServe prompt.
-
- Technical support is available to all users (registered or not) on
- CompuServe with no time limit.
-
- If you're not a CompuServe subscriber and would like a FREE IntroPak,
- call 1-800-848-8199 and ask for operator 154. The IntroPak includes
- FREE sign-up and $15 online credit (so you can explore CompuServe
- without spending a dime!). This free offer is courtesy of CompuServe
- and Custom Technologies.
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 137
-
-
-
-
-
-
- C.2 Association of Shareware Professionals Statement
-
-
- This program is produced by a member of the Association of Shareware
- Professionals (ASP). ASP wants to make sure that the shareware
- principle works for you. If you're unable to resolve a shareware-
- related problem with an ASP member by contacting the member directly,
- ASP may be able to help.
-
- The ASP Ombudsman can help you resolve a dispute or problem with an
- ASP member, but does not provide technical support for member's
- products. Please write to the ASP Ombudsman at PO Box 5786, Bellevue,
- WA 98006 or send a CompuServe message via CompuServe Mail to ASP
- Ombudsman 70007,3536.
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- CheckMate Plus Introductory User's Guide 138
-
-
-
-
-
-
-
-
-
-
-
-
- Index
-
-
- [alt-C] 12, 14 audit lock 106
- [alt-F] 12, 14 audit lock password 107
- [alt-F2] 37 audit trail 106
- [alt-F10] 13, 14 AUTOEXEC.BAT reminder 45
- [alt-J] 35 automatic "reminder" 44
- [alt-M] 14 automatic transactions 38
- .end 65
- [F1] 12, 14 B
- [INS] 14 Balance 35
- (multiplication 92 balance sheet 127
- Balance Sheets 52
- A Bank Credit 27
- account number 24, 118 Bank Debit 27
- account status 26 bar graphs 96
- accounting 115 Begin 78, 82
- accounting equation 116, bottom line 11
- 122 browse 46
- accounting reports 125 browse window 46
- Accounts 21 budget 24, 67
- accounts 118 built-in variables 89
- deleting 25
- editing 25 C
- accounts payable stub 34 calculator 12, 14
- activation date 46 CGA 7, 95, 109
- addition 92 Chart of Accounts 14, 119
- Address 1 79, 91 check layout 24, 76, 77,
- Address 2 79, 91 78
- Address 3 79, 91 designing 77
- addresses 24, 29 language 78
- alt-A 14 preinstalled 77
- Amount 79, 91 Check Number 79, 90
- Amount String 79, 91 check number 24, 29
- ASCII 57, 59 check printing 34, 38, 75
- ASP 138 checking accounts 21, 22
- Assets 21, 115 CheckMate 8
- Association of Shareware CheckMate-GL 8
- Professionals 138 Checks 27
- ATM Deposit 27 checks
- ATM Withdrawal 28 ordering 135
-
-
-
- CheckMate Plus Introductory User's Guide 139
-
-
-
-
-
-
- printing 75 EGA 7, 95, 109
- Cleared 30 End 78, 83
- clearing transactions 72 end-of-month adjustments
- colors 125
- customizing 107 end-of-year routines 133
- Column 78, 82 Equity 21, 116
- COM1 86 exit strings 61, 112
- COM2 86 Expenses 21, 117
- CommasOff 78, 83 exploding windows 108
- CommasOn 78, 83 expressions 91
- Comments 79, 90 numeric 92
- comments 29, 79 string 92
- compounding a fixed sum
- 104 F
- CompuServe 137 FillersOff 78, 83
- concatenation 92 FillersOn 78, 84
- contra accounts 24, 28 filter definition 19
- control account 10, 26 filter definitions
- cost of goods sold 124 deleting 20
- Credits 28 retrieving 20
- credits 121 saving 19
- currency symbol 111 filter flag 12
- custom reports 63 financial calculations
- custom stub 33 103
- fiscal year 105
- D floating point numbers 89
- data entry 14 For 79, 90
- data file path 9
- Date 79, 89 G
- date 29 getting started 9
- date activated graph type 96
- transactions 41 graphics 95
- Date Cleared 30 account activity 96
- date format 110 budget analysis 96
- Date Formats 15 debt to assets 98
- dates debt to equity 97
- entering 13 detailed expense 97
- Debits 28 detailed income 97
- debits 121 expenses by month 97
- Deposits 27 expenses vs income 96
- detail accounts 21, 22 income by month 97
- directories 110
- division 92 H
- double-entry 122 hard disk 7
- headings
- E report 113
- Editing Keys 15 help 10, 12, 14
- editor 16 Hercules 7, 95, 109
-
-
-
- CheckMate Plus Introductory User's Guide 140
-
-
-
-
-
-
- I notes 32, 36
- income statement 130
- Income Statements 52 O
- Input 78, 84 operator 18
- insert 12, 14 order of precedence 92
- installation 7 overwrite 12, 14
- integer 89
- P
- J Page 78, 85
- Justification 87 Page Control 112
- page control 61
- L Paper size 112
- laser checks 75, 77 paper size 60
- laser printers 112 parentheses 111
- LaserJet 112 passwords 109
- Last Date Run 106 past years 105
- Liabilities 21, 116 paste 12
- line graphs 96 Pause 78, 85
- lines per page 60 pausing the printer 61
- loans 103 PayTo 79, 90
- local menu key 13 pin-feed checks 75, 77
- local menus 13 PRINTED 75, 76
- loss 118, 123 Printed 30
- LPT1 86 printer 7
- LPT2 86 Printer Port 112
- printer port 60, 61
- M printer strings 61, 112
- margins 60 PrinterString 78, 85
- mark 30 printing checks in
- mark transactions 47 "batch" 76
- Marked 79, 91 printing to a file 59
- Memorize 33 printing to the printer
- memory requirements 7 58
- Memory status 14 printing to the screen 58
- menu key 14 PrintTo 78, 86
- menu transactions 38 profit 117, 123
- Menus 11
- Mouse 16 R
- mouse 7 real 89
- mouse driver 7 rebuild 99
- MSDOS 7 rebuild menu 99
- multiple "sets of books" rebuilding
- 9 accounts 100
- complete 99
- N index 100
- NewCheck 78, 84 reconciliation 30, 71
- Non-Accounted for Funds repair 99
- 22, 25 repeat options 41
-
-
-
- CheckMate Plus Introductory User's Guide 141
-
-
-
-
-
-
- report date 57 split window 36
- report footer 59 statement date 71
- report headings 113 string 89
- report parameters 60 Stub 78, 86
- report title 59 stub 36
- report utilities 59 Stub Layout 33
- reports stubs 31
- balance sheet 53 subtraction 92
- chart of accounts 52 summary accounts 21, 23
- custom balance sheet system requirements 7
- 53
- custom income T
- statement 55 Tax Ded 79, 91
- default parameters 111 tax deductible 29
- designing 63 technical support 137
- general ledger 50 top line 12
- income statement 54 transaction report
- ledger activity 50 customizing 50
- ledger transaction 51 transactions
- options 57 closing 47
- printing 57 deleting 37
- reconciliation 72 editing 34
- summary 52 entering 28
- transaction 49 trial balance 54, 125
- trial balance 54
- Revenue 21, 117 U
- reverse entries 105 upgrading 8
- running balance 36 utilities menu 32, 37
- running CheckMate Plus 8 report 59
- running scripts 45
- V
- S Variable 78, 87, 88
- savings 104 variable 18
- screen saver 107 variables 68
- script 45 Vendor Account Number 90
- scripts 45 Vendor Acct# 79, 90
- search and filter 12 VGA 7, 95, 109
- Search and Filter video 109
- Operators 18 virtual paper 57, 58
- Search and Filter Window
- 17 W
- setup strings 61, 112 whole numbers 89
- SkipLines 78, 86 Withdrawals 27
- sound effects 108 working messages 12
- special effects 108 Write 78, 87
- Special Keys 13 Writeln 78, 88
- split 30, 36
-
-
-
-
- CheckMate Plus Introductory User's Guide 142
-